Import data from an Excel table into a database by using Navicat

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