Re: Filling mysql db with access db
| From: | Johannes Janson | Date: | Wed, 16 May 2001 16:51:24 +0000 |
| Subject: | Re: Filling mysql db with access db | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9361@lists.php.net to get a copy of this message | ||
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