Read from Excel file

From: Elizabeta (Elizabeta_at_discussions.microsoft.com)
Date: 08/30/04

  • Next message: Andy DF: "Query to set values in an ID Field" 
    Date: Sun, 29 Aug 2004 22:43:09 -0700

    Hi, all

    I am trying to use ado connection object to read an excel file.

    I am not sure how to do it.

    1. I create connection with specified file name (that's easy)
    2. open recordset based on the previous connection, to read one work***,
    like this
        Set rs = cn.Execute("SELECT * FROM [Sheet1$]")

    My problem here is *** name. I don't want to specify it, because it is
    going to be modified. I would like to open just that one active ***,
    currently the only one in a workbook.

    So, the question is 'Is it possible to read active *** in excel file, not
    knwing the ***'s name?'

    Or, is there any other way to do it?

    TIA

  • Next message: Andy DF: "Query to set values in an ID Field"