RE: SQL 2000 + OLEDB

anonymous_at_discussions.microsoft.com
Date: 04/14/04 

Date: Wed, 14 Apr 2004 06:01:44 -0700

No - unfortunately this fails.
>-----Original Message-----
>If you use the syntax listed in :
>
>306397 HOWTO: Use Excel with SQL Server Linked Servers
and Distributed
>Queries
>http://support.microsoft.com/?id=306397
>
>Can you query the Excel table?
>
>Thanks,
>
>Kevin McDonnell
>Microsoft Corporation
>
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>
>
>.
>

Relevant Pages

  • Re: Array formulas wont recognize external data from Microsoft Qu
    ... If this fails, try formatting as general first and repeat either route above. ... Microsoft MVP - Excel ... "Nick Hodge" wrote: ... >>> external data as their data source for calculations. ...
    (microsoft.public.excel.misc)
  • Re: weird, hard to find Excel-automation error
    ... occured on subsequent print out and not on the first one. ... >> Approximately every other time everything runs without problems and fails ... >> I have Access open up Excel with the code below. ... >> Set objExcelDoc = objExcelApp.Workbooks.Add ...
    (microsoft.public.access.modulesdaovba)
  • weird, hard to find Excel-automation error
    ... Approximately every other time everything runs without problems and fails ... I have Access open up Excel with the code below. ... Set objExcelApp = CreateObject'late binding ... If I close and reopen the database, it runs again on the first run and fails ...
    (microsoft.public.access.modulesdaovba)
  • Re: Help - Does value exist in range of CLOSED workbook?
    ... This still fails as described earlier when TEST.XLS is closed. ... TEXT.XLS I get a popup message to the effect: Excel cannot ... array (perhaps as a reference to an array), but to do so it needs to ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Range(0,0).Select ?
    ... Microsoft MVP - Excel ... Pearson Software Consulting, LLC ... the program fails to work so it is apparently doing ...
    (microsoft.public.excel.programming)