Hi All,
I am having an issue with BULK INSERT command in sql. We are having inconsistent data in one of the columns.
Some of the data are within double quotes and hence data is not getting loaded in the correct format in the destination table .How can this be resolved.
Sample data given below
7250,ABCD COMPANY.,SA,PA,ZZZ
7300,DEFG,VE,"VASDFSF",VEF
6100,"ADADSASD",ASDASD,PHI,PHP
We will not be create format file since the data is inconsistent.
Kindly help