Results 1 to 3 of 3

Thread: error help

  1. #1
    Join Date
    May 2003
    Posts
    25

    Unanswered: error help

    I am trying to select data from an excel spreadsheet.. so i use

    select *
    FROM OpenRowSet('MSDASQL','Driver=Microsoft Excel Driver (*.xls); DBQ=c:dt.xls', 'SELECT * FROM [Sheet1$] ' )


    and the error i got is

    Server: Msg 7399, Level 16, State 1, Line 1
    OLE DB provider 'MSDASQL' reported an error.
    [OLE/DB provider returned message: [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.]
    OLE DB error trace [OLE/DB Provider 'MSDASQL' IColumnsInfo::GetColumnsInfo returned 0x80004005: ].


    any suggestions???

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Not too sure about the syntax here, so I could be blowing smoke. Apologies, if I am.

    If the spreadsheet is named dt.xls, should it be DBQ=C:\dt.xls?

    If that is not it, then I would check to see that Sheet1 is in the spreadsheet, and make sure no one has gone and renamed it.

    Hope this helps.

  3. #3
    Join Date
    May 2003
    Posts
    25
    Originally posted by MCrowley
    Not too sure about the syntax here, so I could be blowing smoke. Apologies, if I am.

    If the spreadsheet is named dt.xls, should it be DBQ=C:\dt.xls?

    If that is not it, then I would check to see that Sheet1 is in the spreadsheet, and make sure no one has gone and renamed it.

    Hope this helps.

    Fixed the syntax, and checked sheet1 was there,but still no good, any other suggestions???

Posting Permissions

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