Search code examples
sql-server-2008bcp

BCP Double-quotes text qualifier output

I have a bcp command that is pushing the results of a query into a flat file that is comma delimited unicode. I need the fields to be encapsulated in double quotes with the text identifier being double quotes.

Here's an example of the csv output: 

36029,2,Oct 11 2004  1:01AM,4,23537,0.10

Where it needs to be:

"36029","2","Oct 11 2004  1:01AM","4","23537","0.10"

I suspect it uses the -q flag but I'm not sure how to actually use the -q. The MS documentation is not doing much to help me out.

Sorry if this is a dupe, I looked hard I swear!

Solution

  • try this:

    Exec Master..xp_Cmdshell 'bcp "SELECT '"' + col1 + '"', '"' + col2+ '"', '"' + col3+ '"'
FROM table1" queryout  "C:\mcg1.csv" -c -t,"'