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

[Johannes Janson]

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 unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]