This is a discussion on convert access to mysql within the Programming Articles forums, part of the Webmaster Articles/Tutorials category; convert access to mysql i always wanted to convert my access db to mysql to access it easier on the ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| | #1 (permalink) |
| WMT Addict | 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 |
| | |
| Tags |
| access, convert, mysql |
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Postal Service Access | rustypaulin | Website Reviews | 9 | 06-10-2005 17:13 |
| Postal Service Access | rustypaulin | Ads, Offers & Services | 1 | 16-09-2005 21:48 |
| PHP/HTML/MYSQL - for ??$$ | KF1 | Website Development Forum | 0 | 20-07-2005 17:27 |
| Apache access logs | corona | Php and MySQL | 8 | 09-07-2005 06:05 |