Solved

BCP command to output to delimited file with Quotes and commas

Posted on 2013-10-22
2
412 Views
Last Modified: 2013-10-26
bcp "select * from livedb.dbo.tblValenceInformation" queryout "P:\ACCOUNTING\ValenceTemp.csv" -T -SPTM-DR01 -w -t^,

This command will output a SQL table with COMMA delimits.  How can I modify it to output  text with QUOTE delimiters and numeric/integers with COMMA delimiters?

Thanks

Glen
0
Comment
Question by:GPSPOW
2 Comments
 
LVL 29

Accepted Solution

by:
leonstryker earned 500 total points
ID: 39592002
You can't really output QUOTE delimiters into a CSV file.
0
 

Author Closing Comment

by:GPSPOW
ID: 39603009
Okay
Thanks
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
This is a little timesaver I have been using for setting up Microsoft Small Business Server (SBS) in the simplest possible way. It may not be appropriate for every customer. However, when you get a situation where the person who owns the server is i…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question