Bolte IT Consulting

Import csv / text file into SQL Server

Importing text files into tables in SQL Server database schemas can be done using different methods.

One method using SQL Server specific SQL is shown below.

SQL Script

If you want to use tab delimited source files you can type in the delimiter into FIELDDELIMITER using the tabulator key in SQL Server Management Studio.

BULK
INSERT CSVTest
FROM 'c:\csvtest.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

 

Hits: 9614