Database migration from Access to MySQL
george.patterson at gmail.com
Mon Nov 23 23:54:52 GMT 2009
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
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.
More information about the ubuntu-au