Issue with reading data from remote excel sheet

[ammoos]

Hi Friends,

I need to read data from an excel sheet. I am keeping this excel sheet in a remote machine. I am using OLEDB connection to read the data from this excel sheet. But when I am trying to read the data, then I am getting the error message “It is already opened exclusively by another user, or you need permission to view its data.” I am sure the file is not opened by another user. Then may I know what I have to do for getting permission to read data. Please help me as soon as possible.

Thanks

Ammoos

[semomaniz]

Please post your code.

[Frinavale]

Either you have opened a connection to the file previously and forgot to close it (or someone else is using the file at the same time you are)...or your permissions are incorrect.

By default ASP.NET websites are run using an anonymous user account. This account has restricted permissions and usually is not allowed to read files off of other computers on the network.

You could look into increasing the permissions for this user account (not really recommended) or you could look into using impersonation (google it).

-Frinny

[ammoos]

Thanks for your reply Frinny

[veldanda]

HI ammoos,

How you resolved the issue. Iam also facing the same problem. Kindly provide the Solution ASAP.

Thanks in advance.