Results 1 to 2 of 2

Thread: MORE EXCEL HELP PLEASE!!!

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 1999
    Location
    metairie, la usa
    Posts
    40

    Post

    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

  2. #2
    Member
    Join Date
    Aug 1999
    Location
    Singapore
    Posts
    43

    Post

    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
  •  



Click Here to Expand Forum to Full Width