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, a
Hi,
> How can i import data from an access database to a mysql db.
>
you can export it to a tab-delimited file and then use
LOAD DATA INFILE 'yourfile.txt' into YourTable.
The table structure has to exist.
hope it helps
Johannes
--
PHP Database Mailing List (http://www.php.net/)
To unsubsc
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" <[E
