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
filemenu, then go to
exportand 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.