Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    California, USA
    Thanked 0 Times in 0 Posts

    Excel Interacting With Access (XP; SP3)

    Can someone provide me a resource on how Excel interacts with Access?

    I'm interested in having End Users click on a button to update a database as well as clicking on another button to extract data either using the same format as the update template or a different one.

    I'm not sure how to go about it.

    Any assistance would be appreciated.


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Excel Interacting With Access (XP; SP3)

    Excel has built-in features for retrieving data from an Access database:
    - Data | Import External Data | New Database Query
    - The VBA method CopyFromRecordset

    You could use ADO or DAO to transfer data from Excel back to Access.

    But using Excel as a frontend for Access could be problematic. It's easy to enter invalid data, so you'd have to do a lot of checking that Access would do automatically. (And Access has much better facilities for creating user-friendly data entry forms.)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts