Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

CSV to Excel Expand / Collapse
Author
Message
Posted Saturday, January 26, 2013 10:46 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:35 PM
Points: 285, Visits: 503
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 - Future MCM 2025
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar
I want a personal webpage
I want to win the lotto
I want a gf like Tiffa
Post #1412102
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse