excel usage

  • Thread starter Thread starter nikedog
  • Start date Start date
N

nikedog

I wanted to import legacy data from users in excel in my
asp.net application to my sql server.

I can import the file to the web but when i try to
instantiate Excel w/ CreateObject i get a error "can't
create Active X Component".

I tested my logic w/ a Windows App and it works.

Is office automation permitted within an asp.net app?
Any advice or work arounds?
Thanks for you assistance.
 
It is permitted yes. On what are you trying to createobject. Usually, you
would need to have the owc dll registered and installed. I can't provide
more specific help than this until I know so more intimate details.

regards
 
I appreciate the response. Thanks for the information.

Where can i learn how to permit the 'aspnet' user to have
execute permission on Excel?

I don't want to impersonate on this application.
 
Back
Top