How to convert access to MySQL

access|mysql| Conversion

Access can only be used under Windows This deadly feature makes me sick and determined to convert access to MySQL, but I've found a lot of articles on the Internet that have no direct conversion. I heard that you can use ODBC to turn, just try it.

First installs the MYSQL,MYODBC, constructs a MySQL empty database, adds this database in the ODBC management, specifies the name.

Open the database with access2000, then select the Export, choose ODBC, select the machine data source, choose the MySQL ODBC data source that you just established, and then export.

Only one table can be inverted at a time.

。。。。。。。。。。

Finally finished, now success?

The program in the data source changed to just the MySQL ODBC, found everywhere is wrong, the original MySQL table to the size of the case, changed the program, running feeling good, speed can also.

No, how wrong again, this ID how is empty???

Originally this poured into the database does not support the function of automatic increment.

Continue to MySQL directory, bin run mysqldump pour out all the structure and data to a file my.sql then edit My.sql, modify all the CREATE TABLE statements,
ID int NOT NULL auto_increment, primary key (ID), so that the ID is equivalent to the type of AutoNumber data in Access, run Mysql,drop the original database under Mysql/bin, And then the source again just modified this my.sql all the data back in, OK, this is all done, the program is faster than usual, especially the forum part.

Note: This operation is done under Windows 2000.