EXECL data Import SQL Server method

In the process of daily program development, in many cases, the user unit gives developers the data is often execl or access data, how to convert the data into enterprise-level database data, the following is the use of SQL Server's own features to complete this task.

First open the database, right click on the database, select the task,

Select Import Data

Eject Import Data dialog box

Click Next, in the Data source dropdown box, select the type of data to import, in this case select Execl

Click Browse to select the Execl file that will be imported

Target Select the default, the server select the database server name you want to import data, the authentication method is selected according to the actual situation. The database is the database you are going to import the data into, and you can create your own database.

Select Next, install the default options and click Next.

Then the next step, finally click Finish, to be imported after the completion of the work without error prompts, indicating that the data import work has been completed.

EXECL data Import SQL Server method