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.