Access ODBC Import

depawl · Post by **depawl** » Wed Dec 17, 2025 3:08 am

Greetings All.
So I was able to import one of my MS Access databases into OO using the ODBC connection.
But when I open it in OO, only the tables appear.
No forms, queries, or reports.
Is this normal behavior?
Thanks.

Post by **robleyd** » Wed Dec 17, 2025 11:23 am

Yes, you can only import the data tables.

depawl · Post by **depawl** » Wed Dec 17, 2025 4:08 pm

Thank you for the reply.
Doesn't seem that was made apparent in any of the documentation that I saw.

Post by **MrProgrammer** » Wed Dec 17, 2025 8:40 pm

depawl wrote: ↑Wed Dec 17, 2025 4:08 pm Doesn't seem that was made apparent in any of the documentation that I saw.

A search of the External Data Sources forum quickly found this topic. The topic is ten years old but I doubt if anything has changed since then. Perhaps the links there will help.
Migrating from Access 2010 to OpenOffice - 2 questions

If this solved your problem please go to your first post use the Edit ✏️ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

edit this topic's initial post · Post by **Villeroy** » Wed Dec 17, 2025 9:05 pm

https://ucanaccess.sourceforge.net/site.html is a JDBC driver. It can access the tables and shows the queries as views. Works like a charm on Linux and Windows.
How to connect a new Base document to some Access database

Access ODBC Import

Access ODBC Import

Re: Access ODBC Import

Re: Access ODBC Import

Re: Access ODBC Import

Re: Access ODBC Import