|
-
Sep 24th, 1999, 06:28 AM
#1
Thread Starter
Member
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
-
Oct 3rd, 1999, 03:58 PM
#2
Member
You can use DAO to link to your excel file & the same format hope it works for u.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|