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

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

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
(no e-mails, please!)



"Jess" <(E-Mail Removed)> wrote in message
news:9D88947E-4910-41F6-ADEC-(E-Mail Removed)...
> 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