SQL Server Imports Excel data

One: Create a database:

CREATE TABLE INDUSTRIALTOWNTB ([ID] [NVARCHAR] (PRIMARY) KEY not NULL, Industrialnewcityid [NVARCHAR] ($)  null, Industrialnewcityname [NVARCHAR] ($) Null,industrialtownid  [NVARCHAR] (Null,industrialtownname) [NVARCHAR] ( Null,[isdelete] [INT] null,[createtime] [DATETIME] NULL)

ID, Isdelete, createtime are set as default columns.

2. Right-click Database-Import data

Note that it is consistent with the version in Excel.

Always Next:

View in the database.

SQL Server Imports Excel data