Navicat, Excel
1) First create the test table "student", the table structure is:
2) Then prepare the Excel data sheet for writing:
3) in Navicat Select Student table, right click "Import Wizard", pop up the following window, we select "Excel":
4) Click "Next", "Import from" Select the Excel table just built, click "Next", pop up the following window, here to choose the corresponding "Sheet":
5) Click "Next" to make some settings:
6) Click "Next" to select an existing or new table:
7) Click "Next" to correspond to the fields of the Student table and Excel table in the database:
8) Click "Next", select the option for your own situation, next:
9) Finally, click "Start", we can see the successful prompt:
10) Then we look at the "Student" table, the record is inserted, and here the display has been successful:
Import data from an Excel table into a database by using Navicat