Exporting SQL Server Data to Excel
This video demonstrates how to use the SQL Server Import and Export Wizard to create a package that exports data from a SQL Server database to a Microsoft Excel spreadsheet. http://msdn.microsoft.com/en-gb/library/cc952922.aspx