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
 Old Forums
 CLOSED - General SQL Server
 probelms using excel as linked server

Author  Topic 

senilssonli
Starting Member

7 Posts

Posted - 2005-09-21 : 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

MuadDBA

628 Posts

Posted - 2005-09-21 : 15:50:43
do both PCs have access to the excel document?

are both PCs using the same windows account to run SQL server?
Go to Top of Page
   

- Advertisement -