Re: Re[2]: [PHP-WIN] Database to MySQL

Wihr MyODBC insalled you can use on each teble EXPORT function (in Access) a as file type use ODBC source. There will be displayed allf of your ODBC sources - choose your MySQL database and all the table (with struscture) will be transfered. Ketan *********** Puvodni zprava *********** Dne 21.11.2000 v 9:56 hodin Gonzalo Vera napsal(a): >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 > > > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >For additional commands, e-mail: php-windows-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net