I'm trying to migrate an Access mdb database to mysql but i can't seem to figure on how to do this. Can't anyone give me a sample code on ODBC connection using Access. Thank you and God Bless.
Dripter
ps. pls take note i'm still using PHP3.. i don't know if this still matter. thanks again.
is there any option in Access to create SQL statements for your data? if so then use that, and run the SQL file in mySQL.
sorry, i couldnt be of any more help, but as no one has replied i thought i might just jot something down 🙂
I've tried using pass-through sql in access IDE and i can access the MYSQL data. Run a couple to SQL statements that manipulate the MYSQL database. But when i tried to refer the tables on my access database so i can just issue an insert command in my SQL pass-through statements. My access can't seem to find the reference tables.
Thank you for replying my query anyway. 🙂
http://www.programacion.net/cursos/php/access.htm traslate this url
