Accessing the content of an excel sheet

[Jess]

Is is possible to programmatically access the content of an excel sheet
without an ODBC driver or any other driver?

This is what I would like to accomplish:

At a certain point in my application my users must select an excel sheet on
their computer. Access will access the excel sheet, read and act on the
content. The location of this excel file will vary. How can I accomplish
this? It does not look like an ODBC driver is the way to go.

Thanks for your help

 

[Douglas J. Steele]

One approach would be Automation. See whether my Access Answers column in
the July, 2005 issue of "Smart Access" helps. You can read the column at
http://www.vb123.com/kb/200507_ds_excel.htm or you can download it (and a
sample database) for free at
http://www.accessmvp.com/djsteele/smartaccess.html