Steps to export the SQL Server returned result set to an Excel file -

i have stored procedure going run every weekend, produces result set need export excel file.

for above problem want automate process, going create sql job , going run stored procedure every weekend that generated excel file sent reporter.

for need steps export result set data excel file.

and possible send excel file specific mail while running job itself?

so, might try luck on https://dba.stackexchange.com/, in experience sql agent job running stored procedure coaxed return csv or xml - , end in excel, there missing links. think missing links involve programming , potentially 3rd party tools avoid using excel's com api.

i'd recommend pursuing sql server reporting services. included free edition of sql , includes ability

1. run reports on schedule (subscriptions),
2. format results excel file
3. distribute results via email

you'd take query , use data source "report" , use report wizard create simple table results. avoid page headers (or footers) span columns - keep excel output cleaner.

references

1. stack overflow: reporting-services-export-to-excel-with-multiple-worksheets
2. technet: reporting services