excel usage

[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.

 

[Alvin Bruney]

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

 

[Steve C. Orr [MVP, MCSD]]

There are some security precautions you need to take into account.
Here's all the details:
http://www.aspnetpro.com/NewsletterArticle/2003/09/asp200309so_l/asp200309so_l.asp

 

[nikedog]

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.