Write a special program(xxx) :D
-
Pls suggest me any idea to write a program to convert from MS Access Database to MySQL Database. Thanks and regard. :-D:-D:laugh::laugh: I tried so hard and got so far
-
Pls suggest me any idea to write a program to convert from MS Access Database to MySQL Database. Thanks and regard. :-D:-D:laugh::laugh: I tried so hard and got so far
I use Access to work with several MySql databases by linking tables through the ODBC. First go to http://dev.mysql.com/downloads/connector/odbc/3.51.html[^] to download the ODBC driver for MySql. Create a DSN for the MySql database on your local computer. Open Access, go to File->Get External Data->Link Tables (be sure not to use import, because that will only work locally), and select ODBC in your file type drop down list. Under "Machine Data Sources", select the DSN you created. Select all the tables you wish to work with, and you will get icons for each under your tables list in your access window, except they look like globes instead of tables since they are linked tables. Now that you have the tables set up in access, you can work with them however you want, including queries, forms, reports...whatever.