i always wanted to convert my access db to MySQL to access it easier on the internet. i used acces for my vb programming. i couldn’t use mysql. now i needed the exact db for MySQL. A lot of converters only converted first 5 rows of ech table so i had to do it all my self.
this tutorial is for windows users

1- download a ODBC connector from MySQL site http://dev.mysql.com/downloads/connector/odbc/3.51.html then install it.

2- go to Start > Programs > Administrative Tools > Data Sources (ODBC)
3- Click Add under User DSN
4- Select MySQL ODBC 3.51 Driver then Finish.or whatever version you decided to download
5- Click “Test Data Source”.
6- enter project name , description,host ,your MySQL db name,username and password to connect and fianlly port.
7- when done press ok
If you get an error message saying “Unable to Connect” or words to that effect, disable any firewall or any other means of protection such as anti-viruses you may have running
8- now for each table in your access database right click on it,select ODBC database in the save as type drop menu,enter your database name from step 6 and then that’s it press ok. now you are done. all you have to do is check out your phpmyadmin for the table and its contents.

i hope it helps someone

Popularity: 11% [?]