-
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
-
You can use DAO to link to your excel file & the same format hope it works for u.