Importing specific information from an Excel Spreadsheet

E

Enrique

Hello,

I am trying to retrieve a specific information (Invoice
detail) in an Access 2000 application from an Excel File.

The invoice is in Excel, and my application is in
Access. 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,

(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Update several ppt documents from a single excel file 0
Importing information from an Excel Spreadsheet into Access - Programmatically 1
Access 2K - Retrieving Values From an Excel Spreadsheet 1
Merging from an Excel file with graphics 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Excel issue 0
Using TransferSpreadsheet to import from Excel to Access with variable file names 1

Top