kelvinthong83 (11/18/2010)

---

I have the same problem when importing data from an Excel file to a SQL 2005 database as well but my excel file stored in the SharePoint document library.

I've tried to give full permission to the document library but it still doesn't work.

Error:

The Microsoft Jet database engine cannot open the file '\\serversdev\Documents\QC Files\Prod.xls'. It is already opened exclusively by another user, or you need permission to view its data.