Access 2K - Retrieving Values From an Excel Spreadsheet

  • Thread starter Thread starter Enrique
  • Start date Start date
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.

Enclosed is a sample Spreadsheet I need to get
the Invoice details from.

Thank you very much,

(e-mail address removed)
 
Hi Enrique,

If you need to get data from specific individual cells in the worksheet,
you need to use Automation and the Excel object model.

These articles give the basics of controlling Excel from Access:
http://www.mvps.org/access/modules/mdl0006.htm (and other articles at
www.mvps.orgs/access)

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476

There's also a white paper and code samples including tutorials
available from Microsoft at
http://support.microsoft.com/?id=253235


If however the data you need is laid out as a table occuping only a part
of the worksheet containing the invoice, try using Insert|Name|Define in
Access to give the range a name, and then import this named range to
Access.


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.

Enclosed is a sample Spreadsheet I need to get
the Invoice details from.

Thank you very much,

(e-mail address removed)
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top