RE: [PHP-DB] Filling mysql db with access db

2001-05-17 Thread Michael Rudel

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]




[PHP-DB] Filling mysql db with access db

2001-05-16 Thread Gabriel

How can i import data from an access database to a mysql db.

Thanks in advance,

Gabriel.




Re: [PHP-DB] Filling mysql db with access db

2001-05-16 Thread Szii

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]