Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server

create table

USE Northwind
GO
CREATE TABLE CSVTest
(ID INT,
FirstName VARCHAR(40),
LastName VARCHAR(40),
BirthDate SMALLDATETIME)
GO

BULK
INSERT CSVTest
FROM ‘c:\Test1.txt’
WITH
(
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘\n’
)
GO
–Check the content of the table.
SELECT *
FROM CSVTest
GO
–Drop the table to clean up database.
SELECT *
FROM CSVTest
GO

Advertisement