<div>
<div class="content wysiwyg-content">
bcp &quot;select * from livedb.dbo.tblValenceInfor<wbr />mation&quot; queryout &quot;P:\ACCOUNTING\ValenceTemp<wbr />.csv&quot; -T -SPTM-DR01 -w -t^,<br />
<br />
This command will output a SQL table with COMMA delimits. &nbsp;How can I modify it to output &nbsp;text with QUOTE delimiters and numeric/integers with COMMA delimiters?<br />
<br />
Thanks<br />
<br />
Glen
</div>
</div>


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

BCP command to output to delimited file with Quotes and commas

The Microsoft Legacy Operating System topic includes legacy versions of Microsoft operating systems prior to Windows 2000: All versions of MS-DOS and other versions developed for specific manufacturers and Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions, and Windows Mobile.

Microsoft Legacy OS

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.