Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to convert Access data tables into mysql data tables". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Convert Access data table to data table

There are many ways to search for how to convert on the Internet. But my method seems extremely simple.

Export the excel format file in access and import excel in mysql. The visual operation tool of mysql is so simple!

Specific methods:

Www.2cto.com

1. Select "File"-> "Export"-> "Save Type"-> "excel-"-> enter the file name in the access table.

2. In the Navicat for mysql table, Import Wizard-> excel Type-"Select the file just now-> next->. -> corresponding to the target field and the source field-> start

The premise is that the field data types of the two tables are the same. The primary key will be troublesome. You can convert it first and then change the primary key.

This is the end of the content of "how to convert Access data Table into mysql data Table". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.