transfer MS Access DB files to Ubuntu MySQL

Asked by jamescw

I would like to transfer my Access database files to MySQL in Ubuntu and use Open Office Base to manage them via ODBC

I can export export my MSAccess databases from Access to MySQL in XP and copy the resulting MySQL data files to my shared drive, reboot into Ubuntu 6.10, and see the files, but I can't then pick them up in MySQL in Ubuntu. They don't look like the data files stored in Ubuntu. So, I've been exporting the MySQL tables to tab delimited text files, which I can then pick up in MySQL on the Ubuntu side; although this is very slow.

Once I get the data into MySQL on the Ubuntu side, I try to connect via ODBC but can't manage to find the data. I have instructions for doing this in an apparently earlier version of Ubuntu, but the drivers don't seem to apply to 6.10.

Does anyone know how to do this?

Access is the only reason I'm keeping XP on this dual boot machine.


Question information

English Edit question
Ubuntu Edit question
No assignee Edit question
Solved by:
Last query:
Last reply:
Revision history for this message
David Morris (dave-greenacre) said :

I'm not to sure about Open Office Base, however have you checked to make sure the data is in your mysql server.

If you don't like managing your server on the command line, I use phpmyadmin to manage my databases via a web page. Use it to make sure the data is in your mysql database with the names your expecting.

"When you say 'pick up in MySQL on the Ubuntu side" you mean you import the database files?

Revision history for this message
jamescw (jamescw4406) said :

Yes, the data is on the MySQL server in Ubuntu. I can use the mysql command line to show databases and tables and run select statements. Open Office Base is supposed to be able to act as a front end for mysql via ODBC; I just can't make it work. I have a user (spouse) who's used to Access, Query by Example, Access Forms, and the like, so I need the front end. Thanks.

Revision history for this message
David Morris (dave-greenacre) said :

ok, I've not done it before. However after some reading and searching (as I'll prob give it ago for my mothers databases ) I came across this article, which is done using Ubuntu. They talk about using ODBC and show you how to set it up as well as JDBC, so if thats acceptable you could use that instead. (from my database work, the end user doesn't notice the connection as the GUI's behave in the same way.

Any way the article is here - - let us know if it was helpful.

Revision history for this message
Best jamescw (jamescw4406) said :

Thank you for the article. I got the Java connector to work by following the procedure outlined.