Hi , Can anyone help me in this regard...
My system works on ASP as front end and Sql server2005 as backend. The database server and file servers are on different IPs.I have written a package in which several stored procedures are there and some of them operate microsft excel to generate reports.
I have used Microsoft.OleDB.Jet 4.0 engine to operate excel from stored procedure.
The package runs smoothly but the excel sheets are not generated.
Do I need to install excel.exe in the database server/File server???
Please help me I am in big trouble...
Thanks