Microsoft Access Migration To Mysql Tutorial

Looking back over at a old project I was working on and thought this simple tutorial may come in handy if you have never attempted a database migration.

1. Create MySQL database
2. Download correct MySQL connector from MySQL website =  http://www.mysql.com/downloads/connector/odbc/
3. Now right click on table from Access database which you want to migrate, and choose ODBC Databases and Save as type.
   
4. From to tabs on the top of the select data source form, choose Machine Data Source.
5. Click New button.
6. Choose User data source option 
7. Find the MySQL ODBC driver
8. Click finish

Hopefully you will be presented with a form similar to this

Depending on were your database is stored and username and password fill in the form.

Rinse and repeat for all the tables you need to export.