I have developed web project where in i can import data from excel to gridview and then upload in sql database. My code works fine when i ' using in my PC. After i publish/upload files in IIS server, and try to do the same from my PC, error occured. Error is
The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.
Can anyone help me why such error occured. I have set full permission in the excel file too.
Its urgent plz .........
Loading
CrishPosted Jun 8, 2010, 4:30 AM
you need to give rights to Excel file/folder . give rights ASP.Net,everyone to this file and try again.
Don't forget to Mark Do you like this Answer
that solved your problem!