1

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?

1
  • To expand on @Dekel's answer, there's a video of the process here.
    – Vérace
    Jul 9, 2015 at 15:40

2 Answers 2

1

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.

4
  • 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érace
    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.
    – Dekel
    Jul 9, 2015 at 16:08
  • Well, just a summary should do - it's just as I said though, link rot does occur.
    – Vérace
    Jul 9, 2015 at 16:09
  • Ok, made some changes. I think now it's better :)
    – Dekel
    Jul 9, 2015 at 16:25
1

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

1
  • Can i have this xml file in general format for learning purpose.? Feb 16, 2018 at 12:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.