Re: MS Access data => mySQL database
| From: | Jon Farmer | Date: | Mon, 25 Mar 2002 15:18:50 +0000 |
| Subject: | Re: MS Access data => mySQL database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-90033@lists.php.net to get a copy of this message | ||
> Can anyone tell me how to convert/send data stored in
> an MS Access database to a mySQL table through PHP??
3 Ways of doing this come to mind. Only one uses PHP though.
1. From PHP use ODBC to extract from access and send to MySQL through PHP
functions.
2. Export to csv from Access and use mysqlimport to import into MySQL.
3. Use the MySQL ODBC driver to link the MySQL tables into Access and run a
query to copy the records over.
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969
PGP Key available, send email with subject: Send PGP Key