Results 1 to 2 of 2

Thread: error help??

  1. #1
    Join Date
    May 2003
    Posts
    25

    Unanswered: error help??

    I created a linked server to access information in an excel spreadsheet
    by using this code:

    exec sp_addlinkedserver N'LINKEXCEL_OL',
    @srvproduct = N'',
    @provider = N'Microsoft.Jet.OLEDB.4.0',
    @datasrc = N'C:\dt.xls',
    @provstr = N'Excel 8.0;'

    I created a login using this code:

    EXEC sp_addlinkedsrvlogin 'LINKEXCEL_OL', 'false'

    and I tried to run a query using this code:

    select * from openquery(LINKEXCEL_OL, 'select * from [Sheet1$]')


    Everything is ok until the select when I get this very descriptive error(sarcasm):

    OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider did not give any information about the error.
    OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].

    Does anyone have any suggestions??? I am very lost and do nto see why this wouldn't work..

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    May check this KBA.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •