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 |
|
meenakshisingh0111
Starting Member
3 Posts |
 Posted - 2007-08-03 : 05:06:37
|
| Hi,I need to access excel workbook through SQL server from a remote machine.I have tried using distributed queries with the following syntax.select * From OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;DATABASE=C:\Documents and Settings\136890\Desktop\Compliance Dev\Prototype_Template.xls', 'Select * from [Corporates$]') Where IsNull(value1, '') <> where C:\Documents and Settings\136890\Desktop\Compliance Dev\Prototype_Template.xls' is the datasource and the local machine where the SQL server 2000 is running.Now I need to access data from a remote machine and provide the name of the machine as datasource.Pls adv.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-03 : 11:31:05
|
| Use unc name for file like \\host\share\file, and ensure sql service startup account has permission on it. |
 |
|
|
meenakshisingh0111
Starting Member
3 Posts |
Posted - 2007-08-07 : 00:22:54
|
| Thanks for the reply. However I am not sure how to set the permissions for SQL service startup account.Pls adv |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-07 : 13:07:47
|
| Ask your windows admin for help. |
|
|
|
|
|
|
Access remote data from SQL server 2000