SQL Server dummies tutorial-import a database in Excel.

During system creation, you may often encounter the process of importing an Excel table submitted by the Department. It seems that there are many methods. Here we will introduce the above operations through the Excel import function of sqlserver. OK. Let's get started.

 

Figure 1: Right-click a task in the database and choose import data from the shortcut menu.

 

 

Figure 2: the SQL Server Import and Export function panel is displayed.

 

 

Figure 3: select the Excel option from the drop-down list.

 

Figure 4: select the target Excel file to be imported

 

Figure 5: select the first option

 

Figure 6: Follow the prompts below to get the following page after we confirm the import. We have completed the Excel import.

 

 

Figure 7: The number of tables generated is based on the sheet in the Excel file.

 

 

Figure 8: After the import is completed, we find that there are several database tables in the Chinese $ format in the database. This is the imported Excel table.

 

In this step, the Excel data is already in the database.

Select * From operator line $

The above sentence can be used to obtain data, and then how to import the data to the required database.