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?
-
To expand on @Dekel's answer, there's a video of the process here.– VéraceCommented Jul 9, 2015 at 15:40
Add a comment
|
2 Answers
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 toexportand 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.
-
Just a head's up about DBA.SE. Link only answers are normally frowned upon (link rot). Maybe you could expand on this answer - provide the steps? Also, please use the formatting tools provided - in this case the link tool allowing one to embed the link in a relevant word (Edited).– VéraceCommented Jul 9, 2015 at 15:43
-
@Vérace, thanks for that. As for the steps - they are very easy to produce based on the link, so I thought it will not make sense to just copy what's written there.– DekelCommented Jul 9, 2015 at 16:08
-
Well, just a summary should do - it's just as I said though, link rot does occur.– VéraceCommented Jul 9, 2015 at 16:09
-
The best way to do that is:
- Export Access data to xml
- 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
-
Can i have this xml file in general format for learning purpose.? Commented Feb 16, 2018 at 12:43