Home > IT Answers > Microsoft Windows > Create Excel file on web server by using SQL
SwapnilD
25 pts.
 Create Excel file on web server by using SQL
Microsoft Excel, SQL Server 2005, SQL Server stored procedures
How can I create an excel sheet on web server by using a stored procedure in SQL Server 2005. I'm retriving data from sql select query and creating Excel file dynamically on we server of that data using asp.net. But I want to do this with the help of SQL stored prcedure. i.e. In a stored procedure I will retrive the data required to create file on webserver and in the same stored procedure I want a way to create file to web server.

Software/Hardware used:
ASKED: January 5, 2010  12:02 PM
UPDATED: January 13, 2010  10:23 PM
RELATED QUESTIONS
Answer Wiki:
There is no native way to do this directly from a stored procedure. You can call an SSIS package have have the SSIS package create the Excel file for you. Other than that you'll need third party tools installed on the SQL Server to do this. It is usually better to do this kind of work on the web servers as web servers are much more scalable than SQL Servers.
Last Wiki Answer Submitted:  January 13, 2010  10:23 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts. , ITKE   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _