Database migration from Access to MySQL

[Sridhar Dhanapalan]

2009/11/24 David Bowskill <davidbow at tpg.com.au>:
> Hello All
>
> The way I understand it, the first task is to dump the Access file as a
> CSV file and feed this into a ODBC /MySQL driver to create MySQL tables
> - is this correct?

There are two ways I've used:

 * MDB Tools
 * Pentaho Data Integration

The former can convert MDB to CSV and export the DDL.

The latter is far more powerful, but requires you to make an ODBC
connection to a running instance of Access.

-- 
Bring choice back to your computer.
http://www.linux.org.au/linux