Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003

    Unanswered: Access 2K - Retrieving Values From an Spreadsheet


    I am trying to retrieve a specific information (Invoice detail) in an Access 2000 application from an Excel File. I need it so I can automate the
    process of updating the inventory
    in the Access Database. I will appreciate for any coding ideas on how to open the Excel File from Access, and start retrieving the Invoice information starting at a specific cell, so I can then keep adding the records/details in my Access database, and affect the inventory accordingly.

    Thank you very much,

  2. #2
    Join Date
    Apr 2003
    I am enclosing a sample Excel Spreadsheet with
    the Invoice whose details I need to extract
    and append to an Access Table.

    It is a Zip File.

    Attached Files Attached Files

Posting Permissions

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