Sorry if this is a double post, tried to search but couldn't find the answer.
Does anybody know if there is a bcp version that handles csv files correctly? With that I mean that within the comma delimited file columns that contain a comma that is not a delimeter are enclosed in quotes
BCP will see the second line as having 5 fields, not 2. I need it to import "1,2,3" as 1,2,3 not as 1 and 2 and 3.