I already have my table structure in place in MySQL, and I just want to
import the data from my Access 2000 database. (the .mdb is about 50 megs)
The MySQL server is on a Linux system.
I've been using DBTools to do the import, because it allows me to import
just the data, and not create the
Did you try to make an .csv file and then import it
with Mysql-Front?
I believe that both tables have the same structure.
--- Ian Zabel [EMAIL PROTECTED] : I already
have my table structure in place in MySQL,
and I just want to
import the data from my Access 2000 database. (the
, and then export
to MySQL from there.
Hope that helps...
-Original Message-
From: nick gatsis [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 12, 2002 1:42 PM
To: [EMAIL PROTECTED]
Subject: Fwd: Re: Importing into MySQL from Access
Did you try to make an .csv file and then import
Check out http://www.dbtools.com.br/EN/ I use it to import from access to
mysql. By the sounds of it though you have some dirty data which may or
may not need to be cleaned before going through there program. The only
real problem I had was that working with old dirty data is a pain since a
lot