Quick and Dirty Using BCP to export CSV files

Ta-Dah! TheĀ  switches below in the BCP statement export the results of the query to CSV

BCP "select * from table" QUERYOUT "C:\TEST.csv" -c -t"," -r"\n" -T -S server

:-)

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *