Excel SQL statement Q

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dennis Myrén (dennis_at_oslokb.no)
Date: 11/27/04

  • Next message: Bob Barrows [MVP]: "Re: ODBC/OLE DB Connection Pool" 
    Date: Sat, 27 Nov 2004 03:50:26 +0100

    Hi.
    I use the OLEDB provider for Excel to read Excel files,
    using SQL statements such as:
    SELECT * FROM [Sheet1$]

    Is it possible to form an SQL statement to retrieve all sheets contained
    in a workbook at the same time, rather then one by one?

    Thank you. 

    -- 
Regards,
Dennis JD Myrén
Oslo Kodebureau
  • Next message: Bob Barrows [MVP]: "Re: ODBC/OLE DB Connection Pool"
    • Quantcast