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