Showing posts with label Link Excel with SQL Server 2000. Show all posts
Showing posts with label Link Excel with SQL Server 2000. Show all posts

Wednesday, June 25, 2008

Link Excel with SQL Server 2000

How to use Excel with SQL Server linked servers and distributed queries: "How to use Excel with SQL Server linked servers and distributed queries"
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 = 'XLTEST_SP'
SET @srvproduct = 'Excel'
SET @provider = 'Microsoft.Jet.OLEDB.4.0'
SET @datasrc = 'c:\book1.xls'
SET @provstr = 'Excel 8.0'
EXEC @RC = [master].[dbo].[sp_addlinkedserver] @server, @srvproduct, @provider, @datasrc, @location, @provstr, @catalog

SELECT * FROM XLTEST_SP...Sheet1$