bcp out to a csv file with quoted values

[KCWMS]

using sql server 2k sp2

using master.dbo.xp_cmdshell 'bcp ... ' I can output a query to a text file (csv) with only one problem. I need the values to be wrapped in quotes like this

"1","me","you"
"2","he","she"

I currently get

1,me,you
2,he,she

I am so close. Please tell me that there is a argument I am over looking!!

Thanks in advance

Kevin

 

[nomadicalloy]

Are you using format file to export the data from bcp? You can define quotes on the format file.

Thanks
sqlhelp.blogspot.com

 

[KCWMS]

nomadicalloy,

I have read the BOL and created a format file (interactively) and that works fine... but I do not see anything that specifies how I can wrap values in quotes.

I could alwasy build a query that does this. Is that the only option?

Kevin

 

[nomadicalloy]

you are right you have build your query with '"' quotes.

Thanks

http://www.xpherion.com/blog.asp