lookup a specific cell in Excel

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

Hi all

Is it possible to lookup a specific cell in Excel (C:/Sales/Books.xls, Sheet
(Customers), Cell (D4) and have it displayed in Access reports.

many thanks, Garry
 
See the transferspreadsheet method in VBHelp.. There is a cell range
component you can use for importing only. I believe you will have to set up
a table to hold the imported data. From there, you should be able to use
that field as a source in your report.

Damon
 
Back
Top