I am looking for help to import a.csv file into SQL Server using BULK INSERT and I have few basic questions. Issues: • The CSV file data may have, (comma) in between (Ex: description), so how can I make import handling these data?

• If the client creates the CSV from Excel then the data that have comma are enclosed within ' (double quotes) [as the below example] so how do the import can handle this? • How do we track if some rows have bad data, which import skips? Chessmaster 11th - Grandmaster Edition more. (does import skips rows that are not importable) Here is the sample CSV with header: Name,Class,Subject,ExamDate,Mark,Description Prabhat,4,Math,2/10/2013,25,Test data for prabhat.

Murari,5,Science,2/11/2013,24,'Test data for his's test, where we can test 2nd ROW, Test.' Sanjay,4,Science,,25,Test Only. And SQL statement to import: BULK INSERT SchoolsTemp FROM 'C: CSVData Schools.csv' WITH ( FIRSTROW = 2, FIELDTERMINATOR = ',', --CSV field delimiter ROWTERMINATOR = ' n', --Use to shift the control to next row TABLOCK ). Based SQL Server CSV Import 1) The CSV file data may have, (comma) in between (Ex: description), so how can I make import handling these data? Solution If you're using, (comma) as a delimiter, then there is no way to differentiate between a comma as a field terminator and a comma in your data. I would use a different FIELDTERMINATOR like . Code would look like and this will handle comma and single slash perfectly. Libertango Trumpet Sheet Music.