Convert an Access data table to a mysql data table _ MySQL-mysql tutorial
Source: Internet
Author: User
Convert an Access data table to a mysql data table bitsCN.com
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! Procedure: 1. in the access Table, select File> Export> save type> excel> 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 hss871838309bitsCN.com.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
