You have two big choices:
1. To create the target Excel workbook every time.
2. To update the data in the existing Excel workbook.
Look this article if you want to create the workbook:
http://www.excel-sql-server.com/sql-server-export-to-excel.htm[
^]
The second way is based on using a script that does the following:
1. Opens the workbook.
2. Updates connected tables.
3. Closes the workbook.
This is a good solution as you can customize workbooks for your customers.
You may find ready scripts for this task.
You also have the third way.
You may add your customers to your database and give them permissions to execute several stored procedures to get the data.
As a result, your customers can update the data when they want.
You do not send any file on daily basis.
In addition, you may use the free SaveToDB Express add-in to use Excel as a feature-rich reporting tool.
http://www.savetodb.com/help4/savetodb-getting-started.htm[
^]
Submit an article or tip