servers

I am trying to Link an Excel 2003 spreadsheet to a Enterprise Ed of SQL
Server running Windows 2000 AS.
I add the spreadsheet as a Linked server with the following configuration:
linked server: TEST
server Type: Microsoft Jet 4.0 OLD DB Provider
Product name: Excel
Data Source: c:\temp\new.xls
Security
--
Be made without using a security context - CHECKED
It then makes the connection and I can see the tables and views. When I
click on the table in Enterprise manager i get:
Error 7399: OLE DB provider 'microsoft.Jet.OLEDB.4.0' reported an error.
OLE DB Trace [OLE/DB Provider 'microsoft.Jet.OLEDB.4.0'IDBInitialize
returned 0x80004005: ].
PLEASE HELP !!!May I ask what you are trying to achieve by linking to an Excel
spreadsheet? It is more customary to go the other way and use SQL
Server as the data store, exporting data to Excel as needed.
--Mary
On Tue, 23 Aug 2005 08:48:48 -0700, Sajjad Rizvi
<SajjadRizvi@.discussions.microsoft.com> wrote:

>I am trying to Link an Excel 2003 spreadsheet to a Enterprise Ed of SQL
>Server running Windows 2000 AS.
>I add the spreadsheet as a Linked server with the following configuration:
>linked server: TEST
>server Type: Microsoft Jet 4.0 OLD DB Provider
>Product name: Excel
>Data Source: c:\temp\new.xls
>Security
>--
>Be made without using a security context - CHECKED
>It then makes the connection and I can see the tables and views. When I
>click on the table in Enterprise manager i get:
>Error 7399: OLE DB provider 'microsoft.Jet.OLEDB.4.0' reported an error.
>OLE DB Trace [OLE/DB Provider 'microsoft.Jet.OLEDB.4.0'IDBInitialize
>returned 0x80004005: ].
>PLEASE HELP !!!