Hello,
Usually I use the RDC control in visual basic to communicate with an access database VIA ODBC.
I can use the following code to pull info from a access field

data.sql="select * from <tablename>"
data.refresh
msgbox data.resultset!<fieldname>

I see that ODBC has excel support and I'm wondering how I can open an excel spreadsheet and use similar code routines to pull and write info.
Thanks
Richard Lange