Sorry for the late answer, but better too late than never =8)
OK, there's a tool named access2mysql (but only on Unix).
I think U can get it @ the mysql-web site.
Hope this helps.
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
___
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
___
-Original Message-
From: Szii [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 6:28 PM
To: Gabriel; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Filling mysql db with access db
Export as a comma-delimited file, explode() the file one line
at a time along commas, and use insert via normal methods.
Not sure if MySQL has a parser for comma-delim (probably
does) but this way you have more control over how it goes in.
-Szii
- Original Message -
From: Gabriel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, May 16, 2001 8:47 AM
Subject: [PHP-DB] Filling mysql db with access db
How can i import data from an access database to a mysql db.
Thanks in advance,
Gabriel.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail:
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]