Database migration from Access to MySQL

[George Patterson]

On Tue, Nov 24, 2009 at 9:39 AM, David Bowskill <davidbow at tpg.com.au> 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.
http://www.bullzip.com/download.php (it needs to run on a Windows side
machines) looks good but I haven't used it.

Regards


George