Hi

I have a .csv file which contains some values with comma and those values are in double quotes.
When i bcp , that single value is becoming 2 values and is placed in the wrong field in the table.

How to avoid it .Pls help .
Table has 3 columns
.csv file (ie., input file) looks like this
example :-
wheat,"grown in , NY",Albany

Here these 3 values r going into the table's 3 columns as
first column takes :- wheat
second column takes :- grown in
third column takes :- NY

And Albany is not stored at all in the table .

How can i get 3 values in 3 columns ..

Any help is appreciated ..
Thank You .

create a format file
use ," as first delimiter
and ", as 2nd delimiter

Hi


Pls explain me with one record as an example.

I didnot understand . Sorry for the trouble.

Thank You once again.

Follow this link
bcp in issue