Following is the Microsoft SQL Server T-SQL sample code to insert into an Excel spreadsheet / worksheet from database SELECT:

INSERT OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=d:\excel\SpreadsheetName.xls;Extended Properties=Excel 8.0')...[Sheet1$] select convert(numeric(10,2),ColA), ColB, ColC, ColD, ColE from TableName

Related Link: SQL Server Excel Workbench
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/