Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

BCP command to output to delimited file with Quotes and commas

Posted on 2013-10-22
2
Medium Priority
?
436 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 1500 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Log files are useful in diagnosing and repairing problems.  This is a list of common log files and their standard locations that I've compiled.   While this is not exhaustive, it is a pretty good list that I've found to be useful.  I may update it f…
After several hours of googling I could not gather any information on this topic. There are several ways of controlling the USB port connected to any storage device. The best example of that is by changing the registry value of "HKEY_LOCAL_MACHINE\S…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

926 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