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.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-02-04 : 07:48:51
|
| Hi,Using ssis, is it possible to refresh the data inside an excel file which is sitting on a separate machine (i.e. machine B) on the network?When I try this using the importy wizard, the error message is:The microdoft jet database engine can not open the file \\pathname\data.xls. It is already opened exclusively by another user, or you need permission to view it's data.I have checked and the file is closed. No excel is running when checking the processes.I have given myself full permission on that file from that machine where data.xls is sitting.Thanks |
|
|
prpball
Starting Member
19 Posts |
Posted - 2008-02-04 : 11:55:37
|
| Suggestion. Reboot the computer that the excel file sits on. File may not be open but a process could be running that makes sql think it still is open. If that does not work, try placing the excel file on the desktop of the sql server. This will tell you if it is a permission thing across the network. Also, make sure you are using a UNC name. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-04 : 22:40:06
|
| Sql service account needs permission on that file. |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2008-02-05 : 03:34:22
|
| Ok, I'll try that. thanks |
|
|
|
|
|
|
can not access file