August 23, 2005 at 9:24 am
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 !!!
August 23, 2005 at 10:09 am
Put "Excel 5.0" in Provider string;
Check RPC and RPC out in server option.
August 23, 2005 at 10:14 am
YOU GENIUS !!!!
LUV YA !!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply