lýnked server excel - SQL Server Forums

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

SQL Server 2000 Forums

Transact-SQL (2000)

lýnked server excel

Author

Topic

DENIZ3E
Yak Posting Veteran

56 Posts

Posted - 2006-05-17 : 15:18:18

DECLARE @RC int
DECLARE @server nvarchar(128)
DECLARE @srvproduct nvarchar(128)
DECLARE @provider nvarchar(128)
DECLARE @datasrc nvarchar(4000)
DECLARE @location nvarchar(4000)
DECLARE @provstr nvarchar(4000)
DECLARE @catalog nvarchar(128)
-- Set parameter values
SET @server = 'EE'
SET @srvproduct = 'EE'
SET @provider = 'Microsoft.Jet.OLEDB.4.0'
SET @datasrc = 'c:\SATIS.xls'
SET @provstr = 'Excel 8.0'
EXEC @RC = [master].[dbo].[sp_addlinkedserver] @server, @srvproduct,
@provider,
@datasrc, @location, @provstr, @catalog
----------------------------
SELECT * FROM EE...Sheet1$

SELECT * FROM OPENQUERY(EE, 'SELECT * FROM [Sheet1$]')

---------------------------------------------------------------
:HATA MESAJI:
[OLE/DB provider returned message: Uygulamanýz baþlatýlamýyor. Çalýþma grubu
bilgi dosyasý eksik veya baþka bir kullanýcý tarafýndan özel kullanýmda açýk
durumda.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication
failed.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-05-18 : 12:59:54

The Excel sheet is most probably password protected.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources