Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Problems importing Excel from Web Site

Author  Topic  RMA Starting Member 1 Post Posted - 2009-03-23 : 07:36:10 Hello. I want import an Excel file (by example, with SSIS Import Wizard). If the file is in a local path, there is no problem. But if the file is in a web site ("\\extranet.xxxx.es\sites\xxx\file.xls"), then I get this error: "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.". But if there is any Excel process runing (i can see with task manager), then there is no problem to import. Why?