How to export a table to Excel within a stored proc?

[steve728]

Once I'm done gathering data into a table I need to export it to an Excel Spreadsheet or a .csv file. Is it possible to do this from within a stored procedure? If so please show me an example of the typeical code.

Thanks in Advance!

Steve728

 

[philhege]

SQL2K5:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/9a2405f2-80bc-4748-a019-ac644356d3e7.htm

SQL2K:

ad_impt_bcp_33z9.htm (Copying Data from a Query to a Data File)

Or Google for BCP and xp_cmdshell.

Good luck!

Phil H.
Some Bank
-----------
Time's fun when you're having flies.

 

[j252ewv]

You can also create a dts file and call that from inside a stored procedure, that way you get your column headers as well.