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 |
|
hey001us
Posting Yak Master
185 Posts |
 Posted - 2007-05-24 : 18:49:46
|
| SELECT * INTO #XLSDATE FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=\\10.150.0.46\ECard\simdb070525.xls', 'SELECT * FROM [simdb$]')It’s working fine if the path is in local. (C:\ECard\simdb070525.xls)How do I import XL data from remote? (\\10.150.0.46\ECard\simdb070525.xls)hey |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-24 : 22:26:23
|
| Have to start sql service with domain account that has permission to access remote file. |
 |
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2007-05-27 : 21:04:06
|
| Thanks rmiao. do i need to add each client?hey |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-27 : 22:25:45
|
| Nothing to do with client, just change sql service startup account on sql server. |
|
|
|
hey001us
Posting Yak Master
185 Posts |
Posted - 2007-05-28 : 17:55:05
|
| I fix the issue. thanks much rmiao.hey |
|
|
|
|
|
|
import XL data