5

I am trying to import a CSV file in SQL Server 2008. BULK INSERT is a way to go but it is applicable for CSV from SQL Server 2014 onwards.

What would be an alternative way to achieve this goal?

Any thoughts/ideas much appreciated.

  • 2
    Actually FORMAT='CSV' is 2017+ (14 is the major version number). – Aaron Bertrand Nov 5 '18 at 16:00
9

SQL Server has always supported bulk inserting from CSV files, you just have to specify field/row terminators.

file.csv contains:

foo,bar,1
blat,splunge,2

Then we do this:

CREATE TABLE #foo(a varchar(32), b varchar(32), c int);

BULK INSERT #foo FROM 'c:\temp\file.csv'
WITH (ROWTERMINATOR = '\n', FIELDTERMINATOR = ',');

SELECT * FROM #foo;

Results:

a        b        c
-------- -------- ----
foo      bar      1
blat     splunge  2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.