convert access to mysql
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 excat db for mysql. alot 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 antiviruses you may have running
8- now for each table in your access database rightclick on it,select ODBC database in the save as type drop menue,enter your database name from step 6 and then that's it press ok. now you are done. all you have to do ischeck out your phpmyadmin for the table and its contents.
i hope it helps someone
