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 Answers
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
Following link
If you problem then next link follow I hope solve your problem
https://host4asp.net/import-csv-file-using-sql-server-management-studio/
FORMAT='CSV'is 2017+ (14 is the major version number).