asp.net security: In my web application i am reading the data from excel file and inserting the
records into the database.(In ASP.net C#)

for some users i am getting exception "Access denied" at the following line
of the code.
Excel.Application=new Excel.Application();
for some user it is working fine.
In IIS -->properties-->directory security-->Authentication mode is
"Integrated Authentication" , needed to find the login id of the user.
Web.config file identity impersonate option is also true.
How can i avoid this error message?
Please help...Thanks to all of you for investing the time and replying.

Microsoft does not support using Excel from a server application.

SpreadsheetGear for .NET is a 100% safe managed Excel compatible
spreadsheet component for .NET which works very nicely in server
applications, including ASP.NET - and perform much better than Excel.
It has an API which is similar to Excel and can be distributed royalty
free.

See www.spreadsheetgear.com for a free evaluation.

Joe Erickson
SpreadsheetGear

Hi !
u have to use a different API when creating objects in ASP.NET
use Server.CreateObject

wityh regards
yawar


[quoted text, click to view]