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:

1. Configure a new ODBC DNS connection (this might help)
2. 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
3. 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.

-----------------------------------------------------------------------------------------------------------------------

The best way to do that is:

1. Export Access data to xml
2. Go to phpmyadmin Import that xml file.

Note: if the xml file size is bigger than max upload size import through command line / bash or Terminal