Access to Mysql

[Anon]

Does anyone know of a script to read an access database and create the mysql code to add to a mysql database.

I have tried the plugin for MS Access from www.mysql.com but with no avail.

Kevin Cawthorne

[Anon]

I had success by installing myodbc and running the Visual data manager included with Visual Basic and copying tables from access into the odbc connection.

[Anon]

Here is a work around:

Export Access data to CSV format.

Import the CSV data into MySQL.

Works great for me...

Kai

[Anon]

Many thanks for your help all, I found the best way was to export as a pipe delimited file and import through phpmyadmin.

But that doesn't stop me wanting a script to do it all for me without the export/import hassle, so if anyone feels up to doing one - I'll buy that!

Kevin