Did you specify the double quotes as the text qualifier? if not it'll read the comma's inside the quotes...
example:
"test, test1,test2","xyz name","some id"
will read:
Col1 Col2 Col3 Col4 Col5
"test test1 test2" "xyz name" some id
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D