How to export an Access database and import to MySQL? I am working on a Java project that sources data from an MS Access database, but I want to use MySQL because I have found it to be very easy to manage. How can I export an Access database that has tables of 8 MB and more, and move the data to MySQL?
You can use ODBC to connect from MSAccess to MySQL.
Here is an example.

What you should actually do is:


Configure a new ODBC DNS connection (this might help)
Inside access - click on the table you would like to export, click on the file menu, then go to export and choose the name for the export
Select the ODBC connection you just created from the list of files of type.


MSAccess will connect to your MySQL server and export the data in that table to your MySQL database.