Importing an entire MSAccess db in one go

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
norster
Posts: 6
Joined: Wed May 07, 2008 9:49 pm

Importing an entire MSAccess db in one go

Post by norster »

I know this can be done, but I require the Queries and Reports to be displayed under Queries, and Reports - not all under Tables.

Is this possible ?

I'd like to move away from Micro$oft, and currently use as much open source as I can.

I use Windows XP (sp3).
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Importing an entire MSAccess db in one go

Post by Villeroy »

No application other than Microsoft Access can read mdb files. Even if OOo could do that there would be no real equivalent to forms and reports. Forms and reports in Base are embedded Writer documents. They are by far less sophisticated than forms and reports in Access. When some database frontend imports data from some database backend, it uses some driver which can serve the resulting recordsets of SELECT-queries. Sometimes the driver can update, insert and delete as well. This is exactly the same when you import any foreign database (e.g. MySQL) into a MSAccess frontend. You install a driver, register an odbc datasource and connect Access to the datasource. Then you define queries, forms and reports with the built-in tools of the MSAccess frontend.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply