Access to MySQl

[Anon]

Looking for a right idea how to bring 2,000 records from Access 2000 on PC into MySQL database
on-line, on my hoster's server.

Sergei

[Anon]

Just a suggestion:

(1) Generate SQL scripts from ACCESS and build your MySQL tables from the script.

(2) Dump your ACCESS data into a text file (perhaps a CSV format).

(3) Write a little bit PHP codes to read the text file and push the data into the MySQL tables.

Comments from anyone?

[willh]

I usually use the MySQL ODBC driver and export the tables but you can get odd column types. Or you could link the MySQL table to the access database and create and INSERT ... SELECT ... type query to copy across the data.

just my ideas not the way the csv dump is a good one.

Will