Database migration from Access to MySQL

George Patterson george.patterson at
Mon Nov 23 23:54:52 GMT 2009

On Tue, Nov 24, 2009 at 9:39 AM, David Bowskill <davidbow at> wrote:
> 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?
> If this is correct, can anyone point me to a suitable ODBC driver ?
> If I am talking through my hat, please give me some guidance.
> Many thanks
> David Bowskill

Hi David,

CSV files would work but is slow.

While it was a while ago since I migrated data from Access to MySQL, I
used a script which would dump a mysql dump file. There are plenty of
conversion scripts and programs out there. (it needs to run on a Windows side
machines) looks good but I haven't used it.



More information about the ubuntu-au mailing list