How to export an Access database and import 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.