Import Excel File - Permission problem

[Legions]

Hello all!

I'm having a problem with a .NET project. The program allows a user to import Excel files. Within the excel file is data within a grid. This grid is imported into a table within the .NET program (ADO.NET) and then analysed within the program.

The problem is that when the user downloads the Excel files, the program gives an error of not having permission to access the excel file when using connection string.

So to work around this - we are having to manually right click the excel file and change the permissions to make it accessible by IUSR_Computer Name...

Does anyone know a work around for this? We are working under .NET 1.1 Framework.

Thanks in advance,

-L

 

[RonRepp]

L:

Is the .Net program opening Excel?

If so, are you using it in early or late binding?

If not, try turning your project into a com object and access it through the activeworkbook.

I hope this helps.

Ron

Ron Repp