Access can only use this deals in Windows, I am deeply evil, and I am determined to convert Access to MySQL, but I have found a lot of articles online, there is no direct conversion. I heard that I can use ODBC to turn, I try it. First install MySQL, MyodBC, build a mysql empty database, add this database in ODBC management, specify the name. MySQL Connector / ODBC 3.51 Download Point: http://dev.mysql.com/downloads/connector/odbc/3.51.html Opens the database with Access2000, then select, select ODBC, select the machine data source, select your own created good MySQL ODBC data source, determine after export. I can only fall a table at a time. . . . . . . . . . . Finally, is it successful now? Improve data from the data in the program on the MySQL ODBC, found that it is wrong, the original mysql's case is distinguished, change the program, running, and speed can also. No, how is it wrong? How is this ID empty? ? ? It turns out that this plugged database does not support automatic incremental features. Continue to the mysql directory, bin runs mysqldump down all structures and data to a file my.sql and edit my.sql, modify all CREATE TABLE statements, ID int not null auto_increment, primary key (id), this ID It is equivalent to the automatic number data type in Access, running mysql, Drop dropped the original database under mysql / bin, and then Source has recovered in this my.sql all the data, well, this whole, the program It is often much faster than it, especially forum. Note: This operation is made under Windows 2000.
