Mark, I am pretty much sure that there is no double quotations in my csv file. i am puzzled how they are coming in the result

surya

any can help me how many rowterimator characters availble. i knew about '\n\,'\r' is there any other characters for row termination in the case of bulk insert

Thanks in advance

I would like to explain my scenario first. i have a .csv file 836 rows in which some columns may not have values when i wrote an bulk insert statement...

Yes, Bledu . I ran in QA

I followed the steps provided by Moden. I executed the bulk insert statement you provided me

The result I got is...

Hi Morris,  Here is the data of my csv file in excel spread sheet.

col1,col2,col3

Yes, I ran the query provided by Bledu. I got the results as shown below.

col1,col2,col3...

I followed the steps provided by Mark. I created a Schema.ini file as suggested. The content of Schema.ini file is