scott_botkins1 — 2007-06-20T10:55:48-04:00 — #1
I have a .mdb file that is 63mb. It contains information that needs to be displayed on the web by tables and rows. I'm needing to have it be placed in .sql for mysql so I am able to do what I need it to do. What would be the best solution to do this? Thanks.
groberts — 2007-06-20T12:06:08-04:00 — #2
byron3_earthlink — 2007-06-20T12:07:26-04:00 — #3
Have you installed ADODB ?
Documentation @ : http://phplens.com/lens/adodb/docs-adodb.htm#ex1
Create duplicate tables in mysql to store the data, open both databases, use two different connections. One for your .mdb and one for your mysql database.
From thee it is straight forward processing, read all the records form one table in the .mdb and write the data one record @ a time to your mysql database.
ldivinag — 2007-06-20T16:46:20-04:00 — #4
use the FREE access (and other dbms) converter from mysql...