Background:
First of all, I tried to import excel directly. Since there were more than 200,000 rows of data to be imported, only tens of thousands of rows were imported in the end. Therefore, I tried saving the .xlsx file as a .csv file and the import was successful.
(Recommended tutorial: navicat)
The specific steps are as follows:
1. Create a connection
I chose SQLite here , it depends on the database you want to use
2. After creating the database:
Double-click to open it and there will be The following structure
3. Save your table as a .csv file, right-click "Table" and select Import Wizard
4. Select the source file
The above is the detailed content of How to batch import excel table data in navicat. For more information, please follow other related articles on the PHP Chinese website!