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 |
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? |
|
|
|
|
|