Hi,
I am facing the following issues and hoping that someone out there would have a resolution to the issue:
1) I am currently working on a web application which handles the payroll data for 40000+ employees.
2) The application needs to spool web based reports in Excel sourcing the data from the backend using regular queries.
3) I am currently stuck at the part when I need to generate an Excel file with multiple sheets and formatting using the records generated. I do not want to use any iterations as that would cause the reports to take a huge time to get generated. I would rather want to do it the regular way as can be done in any VB application by throwing the entire recordset into an excel file in one go.
When I'm trying to do this using the createobject method on the server side, i'm getting the following error:
Server object error 'ASP 0178 : 80070005'
Server.CreateOb ject Access Error
The call to Server.CreateOb ject failed while checking permissions. Access is denied to this object.
If anyone can assist in this regard, would be really grateful.
Thanks.
I am facing the following issues and hoping that someone out there would have a resolution to the issue:
1) I am currently working on a web application which handles the payroll data for 40000+ employees.
2) The application needs to spool web based reports in Excel sourcing the data from the backend using regular queries.
3) I am currently stuck at the part when I need to generate an Excel file with multiple sheets and formatting using the records generated. I do not want to use any iterations as that would cause the reports to take a huge time to get generated. I would rather want to do it the regular way as can be done in any VB application by throwing the entire recordset into an excel file in one go.
When I'm trying to do this using the createobject method on the server side, i'm getting the following error:
Server object error 'ASP 0178 : 80070005'
Server.CreateOb ject Access Error
The call to Server.CreateOb ject failed while checking permissions. Access is denied to this object.
If anyone can assist in this regard, would be really grateful.
Thanks.