Convert an Access data table to a mysql DATA table

There are many methods to convert an Access data table to a mysql DATA table and search for it online. However, my method seems extremely simple. Export an excel file in access and import it to mysql. Mysql's visual operation tool is really simple! Specific practice: www.2cto.com 1. In the access table, select File> export> Save type> excel> Fill in file name 2. In the Navicat for mysql table, import wizard-> excel type-select the file just now-> next->... -> Corresponding target column and source column-> the premise is that the field data types of the two tables are consistent. The primary key is troublesome. You can convert it first and then change the primary key author hss871838309.