Add Headers name in the csv

Question

Goal:
I want to add some name of the column's header from stored procedure to the CSV file

bcp "EXEC [databasname].[storedprocedure]" queryout C:\test\bcp_outputTable.csv -c -T -SPC01 -r\n

Problem:
I cannot find a solution to it.

Info:
I'm using the code above in CMD.

Potential duplicate of http://stackoverflow.com/questions/1355876/export-table-to-file-with-column-headers-column-names-using-the-bcp-utility-an — Scott C, May 11 '15 at 13:25
In this context I cannot change the code of the the stored procedure due to many reason. — HelloWorld1, May 11 '15 at 13:30

score 1 · Answer 1 · answered May 11 '15 at 18:47

1

rename "C:\test\bcp_outputTable.csv" "C:\test\bcp_outputTable.txt"
echo HeadRow1,HeadRow2,HeadRow3,... >"C:\test\bcp_outputTable.csv"
type "C:\test\bcp_outputTable.txt>>"C:\test\bcp_outputTable.csv"
del "C:\test\bcp_outputTable.txt"

answered May 11 '15 at 18:47

Stephan

53,940
10
58
91

score 0 · Accepted Answer · answered May 12 '15 at 07:23

@ECHO off

SET "location=c:\test\" SET filename=%date:~0,10%

ECHO This bat creates a csv file to the to the folder %location% ECHO If you are ready, press the button space

PAUSE

BCP "[databasname].[storedprocedure]" queryout %location%%filename%.txt -c -T -t; -SPC01 -r\n

:: Adding header in the csv file ECHO f;f;f> %location%%filename%.csv

TYPE %location%%filename%.txt >> %location%%filename%.csv

DEL /s %location%%filename%.txt

PAUSE

Add Headers name in the csv

2 Answers2