SQL Server: BULK INSERT for insert data from Flat file (CSV) to Table

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing a demonstration of BULK INSERT for inserting data from flat file into the table of SQL Server.

As an ELT developer or database developer, this is a ubiquitous requirement to import external file data into the table of SQL Server.

Please check below demonstration and try it your self.

Create a sample table:

CREATE TABLE dbo.tbl_Employees

(

empid int

,empname varchar(10)

,empgender varchar(6)

,empsalary int

)

Add sample data in .csv file and save it:

Use BULK INSERT for inserting data into the table:

BULK INSERT dbo.tbl_Employees

FROM 'D:\empdata.csv'

WITH

(

FIRSTROW = 2,

FIELDTERMINATOR = ';', --delimiter

ROWTERMINATOR = '\n', --For next row

TABLOCK,

CODEPAGE = 'ACP'

);

Check the result of SELECT:

1	SELECT *FROM dbo.tbl_Employees

Result:

empid empname empgender empsalary

----------- ---------- --------- -----------

1 anvesh male 150000

2 roy male 120000

3 jenny female 60000

4 nupur female 90000

Sep 12, 2017Anvesh Patel