Last post Feb 16, 2011 11:39 AM by ddelella
Feb 16, 2011 11:25 AM|sullenest|LINK
I am very new to asp.net and SQL server. I am helping out my team by researching the possibility for any user to download reports into Word and Excel from the SQL database by simply clicking a button. Any information, links, codes or commerical product recommendation
wiould be appreciated.
Feb 16, 2011 11:39 AM|ddelella|LINK
The most common way of writing to Microsoft Office products is by using the Microsoft Office Interop. The dlls are free and can be downloaded over the web. If you google for examples on how to use them you will find plenty. Excel is better for reporting
than Word but if you are using SQL Server you may also look into SQL Reporting Services (depending on what license you have).