in reply to Transferring an Access Database to mySQL

Kev, Please, download, http://www.hostcl.com/zip/exportar.zip This bas module was adapted to export all tables from databases to xxx.txt. Using xxx.sql itīs fine. Hope you can read some spanish! Change database name and name for text files as your requires. Call exportSQL funtion w/o parameters from any form in your vb app. The best way to give the txt file to mysql have been with phpMyAdmin. The file delete tables in your mysql database, re-create empty tables and transfer data for that table, one pass for table. Best from Santiago de Chile Charliej

Originally posted as a Categorized Answer.

  • Comment on Re: Transferring an Access Database to mySQL