On Friday, January 30, 2004, at 03:12 AM, [EMAIL PROTECTED] wrote:
There was some discussion in December of converting MS Access
databases to Mysql and the DBManager program was recommended.
I have recently converted access to mysql. I used access to import a
CSV file and ensured all data was
Hi Arthur,
Dbtools is a free product and it will do the conversion for you.
http://www.dbtools.com.br/EN/index.php
We have had success converting from MSAccess to MySQL in the past with
it.
Regards,
Matt
-Original Message-
From: Arthur Klimowicz [mailto:[EMAIL PROTECTED]
Sent:
I'm new to MySql as well but the LOAD DATA statement is probably what
your looking for. It's a bulk loader and dumps the data from a flat file
into a designated table for you. You could easily automate this by writing a
simple perl script(probably php also but im not to familiar with that
Arthur
On converting data from MS Access. I've done this several times myself, and
found the easiest way is to:
1. Create your mySQL database tables
2. Define a DSN (ODBC Connection) from your workstation to the mySQL
database
3. Link the mySQL tables into your MS Access database
4. Copy the