sql server programming: Link tabke question??? -- sql server programming

Link tabke question???

Paul
6/22/2004 10:46:54 PM

sql server programming:

How to create a link table to Excel. I am running on SQL 2000 and I need to
create three link table to three Excel worksheets. Can it be done? I need
the link table not importing data from Excel to a SQL table as I need the
real time link i.e.data in SQL tables can be updated instantly when data
changed in the Excel worksheets. Also the SQL tables can be accessed from
other Office application like Access using ODBC connection. Thanks

Re: Link tabke question???

Uri Dimant
6/23/2004 9:46:32 AM

Paul
BOL says:

To create a linked server definition using the Microsoft OLE DB Provider for
Jet to access an Excel spreadsheet, first create a named range in Excel
specifying the columns and rows of the Excel worksheet to select. The name
of the range can then be referenced as a table name in a distributed query.

EXEC sp_addlinkedserver 'ExcelSource',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'c:\MyData\DistExcl.xls',
NULL,
'Excel 5.0'
GO
[quoted text, click to view]