Re[2]: [PHP-WIN] Database to MySQL
| From: | Gonzalo Vera | Date: | Tue, 21 Nov 2000 15:56:43 +0000 |
| Subject: | Re[2]: [PHP-WIN] Database to MySQL | ||
| References: | 1 2 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-4026@lists.php.net to get a copy of this message | ||
Another easy way is to attach MySQL tables to Access using MyODBC, and
you can then do all data exporting using an Access append query. This
solves data transfer, not structure copying: you'll have to use other
methods or hand-make your MySQL tables.
Gonzalo.
SA>> IS there any proper known method of transfering a Access or MSSQL to MySQL ?
SA>> if so.. how do i go about it both ???
> The simplest way I have found is to export the database from access to
> tab delimited file. Then using MySqlimport function to import the
> data.
> There is a great section in the manual on import. /mysql/Docs/manual.html#mysqlimport