about how to import Excel data into SQL Server

In the face of a lot of Excel data we may be very distressed, if one of the inserted into the database, not only a lot of time, but also possible errors, and now I say how to import data!

1. Preparatory work

The first thing to do is to create a data field in Excel that corresponds to a data table, such as:

Fields corresponding to the database:

2. Data import

　　

Remember to select Excel

Then click "Browse" to select the target data you want to import, click "Next", enter the server name, login name and password:

Next:

Next:

Select the data table you want to import here, or you can name a new table yourself:

Click "Preview" to view our data:

Click "Next":

Last "Done"

Let's take another look at the effect:

about how to import Excel data into SQL Server