|
senilssonli
Starting Member
7 Posts |
 Posted - 09/21/2005 : 02:44:53
|
I get an error when I
-----------------------------------------
EXEC sp_dropserver 'ExcelSource'
EXEC sp_addlinkedserver 'ExcelSource',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'C:\Local Data\Data\Geography\GSMORGOPERLIST fixad.xls',
NULL,
'Excel 5.0'
select *
from ExcelSource...[Blad1$] xls
--------------------------------------------
It works fine on one PC but not on the other. Can anyone give me a hint. (the excel file is not open in other application, it is a proper xls-file without filers turned on.
brgds/Lasse
|
|
probelms using excel as linked server
Forum Locked
