Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a .mdb file on my computer that I would like to convert into a MySQL Schema and I have found that there is a migration tool within Workbench. However it doesn't seem to allow you to connect to a .mdb instead it looks for a server. How should I either link to my file or host my file easily as I have not done this before.

share|improve this question

You can use MySQL Workbench to connect and migrate your schema/data from MS Access to mySQL. First you need to configure an ODBC Data Source:

  1. Click Start, and then click Control Panel.
  2. In the Control Panel, double-click Administrative Tools.
  3. In the Administrative Tools dialog box, double-click Data Sources (ODBC). The ODBC Data Source Administrator dialog box appears.
  4. Click User DSN, System DSN, or File DSN, depending on the type of data source you want to add. Click Add.
  5. Select the driver that you want to use, and then click Finish or Next.
  6. Follow the instructions and enter the required connection information in any dialog boxes that follow.

Back on MySQL Workbench: Use the menu Database > Migrate and select the ODBC data source you've created to use as source for your job.

share|improve this answer

As a supplement the response @marcelo-rodrigo, you can use Workbench or another tool but you will need to export table relations too (Workbench and other tools doesn't exports relations)

I write a code to extract all table relations from MS-Access database as SQL and run it on MySQL after export. Link to Code at Github Gist.

See: Converting MS Access to MySQL with relationships

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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