How to convert the Access database to a Mysql one?
This is the vay how I do it
You have to build a databse in mysql and tables export database from acces as CSV and then import in mysql
I want the table structure to be transfered exactly as it is in the Access database
there are a few programs to do this, see this one: http://www.topshareware.com/Access-to-MySQL-download-973.htm
there is a free trial, see what you can do with it.
Access to Mysql converts only the first five row of each table.
Found a script that will do just what you want. You run it as a module in Access to generate two text files with all the info you need.
http://www.mysql.com/get/Downloads/Contrib/exportsql.txt/from/http://mysql.zawodny.com/
Enjoy!
