How to convert access to mysql_MySQL-mysql tutorial

Access can only use this same life-saving feature in windows, which makes me feel terrible and hard to switch access to mysql. However, I have found many articles on the internet and have not directly converted it. I heard that odbc can be used for conversion, so I tried it. Install mysql and myodbc first, create an empty mysql database, add this database to odbc management, and specify Access

Access can only use this same life-saving feature in windows, which makes me feel terrible and hard to switch access to mysql. However, I have found many articles on the internet and have not directly converted it. I heard that odbc can be used for conversion, so I tried it.

Install mysql and myodbc first, create an empty mysql database, add the database to odbc management, and specify the name.

Open the database with access2000, select Export, select odbc, select the machine data source, select the mysql odbc data source you just created, and then export it.

Only one table can be inverted at a time.

..........

Finally, is it successful now?

Change the data source in the program to the mysql odbc, and find errors everywhere. The original mysql table is case sensitive. after the program is changed, it feels good to run and the speed is fine.

No. why is it wrong? how is this ID empty ???

In the past, the imported database does not support the auto-increment function.

Continue to the mysql Directory. run mysqldump in bin to output all the structures and data to the file my. SQL, edit my. SQL, and modify all the CREATE TABLE statements,
ID int not null auto_increment, primary key (ID), so the ID is equivalent to the automatic number data type in access. run mysql in mysql/bin and drop the original database, next, let's look at the modified my. all SQL data is restored. this is all done. The program is much faster than usual, especially in the forum.

Note: this operation is performed in windows 2000.