How or can you save or export an SQL Server 2008 table to a Microsoft Excel File?
I am running MS SQL Server 2008. I use it in connection with a Visual Basic 2008 program that I put together using Visual Studio 2008/SQL Server 2008. My customer wants me to send her inventory in a Microsoft Excel spread sheet. I have been sending PDF files from my program. I was thinking that maybe I could some how pull the spreadsheet directly out of SQL server. Is there any way I can give her the Excel spreadsheet?