Shulou(Shulou.com)06/01 Report--

This article is to share with you the content of an example of bulk importing excel table data into navicat. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Background:

First of all, I tried to import excel directly, because there are more than 200,000 rows of data to be imported, but only tens of thousands of rows are imported in the end. Therefore, I tried to save the .xlsx file as a .csv file, and the import was successful.

The specific steps are as follows:

1. Create a connection

I chose SQLite here, depending on the database you want to use.

2. After creating the database:

Double-click to open it and you will have the following structure

3. Save your form as a .csv file, right-click "Table" and select Import Wizard.

4. Select the source file

Here you can adjust the table structure to see your own needs. There is no need to modify it, just the next step.

Import complete!

A problem encountered:

There are several rows of data import errors, [Err] [Imp] 1-unrecognized token: "'xxxxx".

Error analysis:

This is because I have spaces in my form, so it would be nice to remove the spaces in the original form. Note that the blanking operation here needs to be modified in the .xlsx file, the modification in .csv will cause data problems and you may not find it. How did I find out ~ because after the .csv was changed, the zeros of the data at the beginning of 0 in me are gone.

Thank you for reading! The example of navicat bulk importing excel table data is shared here. I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

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.