Home  >  Article  >  Database  >  How to import tabular data in navicat

How to import tabular data in navicat

angryTom
angryTomOriginal
2019-08-06 16:37:2713181browse

How to import tabular data in navicat

Sometimes, we need to import the data in the Excel table into the database. Here I will teach you how to use Navicat to import the data in the Excel table into the database.

Recommended tutorial:MySQL introductory video tutorial

1. Select the specified data table name, right-click and select Import Wizard

How to import tabular data in navicat

2. Select the file type as Excel

How to import tabular data in navicat

3. Select the file to import from your computer

How to import tabular data in navicat

4. Select a page in Excel

How to import tabular data in navicat

5. Then fill in some relevant content

How to import tabular data in navicat

6. Determine which columns you want to import. Sometimes you may not need to import all the columns in Excel into the database

How to import tabular data in navicat

7. Then click Start. After it is displayed as Finished, it means The import is successful

How to import tabular data in navicat

#8. Then you can see that the imported database table is here, and the displayed content is also the data in Excel

How to import tabular data in navicat

The above is the detailed content of How to import tabular data in navicat. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn