The BCP program makes it very easy to export data from SQL Server to Excel.
The attached stored procedure will do this:
USP_OUTPUT_TO_XL.sql (3.85 kb)
and below is a sample call:
EXECUTE [dbo].[USP_OUTPUT_TO_XL]
'THE_DB_NAME'
,'THE_TABLE_NAME'
,'C:\Docume~1\ME\MyDocu~1\ME.XLS'
,'THE_USERNAME'
,'THE_PWD'
,'THE_SERVERNAME'
SQL Server
bcp, excel