Is It Possible To Use SQL Server To Add A Header Row To Existing Excel Spreadsheets?

Question

Hello Forum

We have a process here that produces several dozen Excel Spreadsheets every day from SQL Server using the bcp utility.  the problem is that we cannot include the column headers when producing the Output.  We are therefore trying to find a method where we can append the column Headers to the Spreadsheets; is there a way of doing this?

Many thanks

---

Please click "Mark As Answer" if my post helped. Tony C.

Answer 1

Can't you just export the data with the headers intact?

http://stackoverflow.com/questions/10677133/saving-results-with-headers-in-sql-server-management-studio

Here's a VBA solution to update all Excel files in a folder.

http://www.rondebruin.nl/win/s3/win010.htm

---

Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.

Answer 2

Have you seen this as a way to add headers to the bcp output?

http://stackoverflow.com/questions/1355876/export-table-to-file-with-column-headers-column-names-using-the-bcp-utility-an

You could also migrate to using SSIS, that will let you include headers. If you do this then I really really recommend spending a day or so learning BIML and doing it in that as even a week learning BIML will pay back pretty quickly.