Basit Khan

Basit Khan

  • 1k
  • 336
  • 115.7k

BULK SQL Query in SQL

Nov 2 2015 11:15 PM
Dear,
I'm inserting CSV data into SQL Server.
Below is the code.
BULK
INSERT AA_Temp
FROM 'D:\A\33.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
What my problem is my CSV file has a header, without having header is successfully inserted.
How to skip the first header, i tried above code but got error type mismatch beocz of getting first header row.
Thanks
Basit

Answers (5)