There is a program at http://www.convert-in.com/acc2sqlp.htm which will
create the MySQL tables from the Access 2000 database and populates
created tables directly from the Access 2000 source. It also converts
date/datetime fields into MySQL format and Yes/No fields into tinyint.
The best news is
To convert Access DB to MySQL check this URL
http://www.urbanresearch.com/software/utils/urbsql/
theOtherOne
- Original Message -
From: "Gary Portellas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 22, 2002 2:45 AM
Subject: Converting Access 2000 to Mysql
>
> Hi Al
I think the best way is to export Access 2000 tables to tab
delimited text files and then use mysql LOAD DATA INFILE in mysql
to get data from text files into MySQL tables.
See manual for LOAD DATA INFILE syntax.
I'm not sure but maybe some utilities exist to convert Access to MySQL.
Peter.
>
