Bulk Insert and FieldTerminator Problem
I am using a bulk insert to bring the contenets of a csv file into a temp table. The insert works but I found a new problem, some of the fields have a ',' in the middle of the field.
My field terminator is ','
"Joseph Abcde","Partner","Joseph.Abcde@xxxx.com","PasswordNotRequired, NormalAccount"
"Joseph W. Wecfder, Jr.","Partner","Joseph.Wecfder@xxxx.com","NormalAccount"
Notice the comma right after the last name and before the suffix on the 2nd record.
Anythin I can do about that?
It's a pain, but you have to use a format file: