Read Excel data row by row in sql server 2005 database it work on localhost but not on server ?

Question

Sir I am mangal sisodia subscribe of C-SHARPCORNER.COM & With respect i have trouble in asp.net c# i want to read excel file row by row using file uploader in database it is work on localhost well but when i upload on server and then i select file by fileuploader & click ok then it will generate following error: System.Data.OleDb.OleDbException: 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. Please sir guide me what is actual problem and give me solution for it. I am waiting for the your response mail. Regards Mangal Sisodia

Mahesh Chand · Answer

Your server needs Excel COM component to process it.

Crish · Answer

hi you need to give rights to this .mdb file on your server using your control panel. once you will give rights then after it will work fine. Don't forget to Mark Do you like this Answer that solved your problem!

PJ Martins · Answer

where is the Excel file located which you are trying to upload on the server on on a local machine?