lookup a specific cell in Excel

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
 
D

Damon Heron

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
 

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

Update several ppt documents from a single excel file 0
Autonumber field in Excel that behaves the same as Access 0
Need Help with a VBA subroutine 0
Cell data entering slow! 0
Merging from an Excel file with graphics 1
Excel does not accept text format! 0
Integrating information from Word to Excel (not mail merge) 1
How to select database dependent on lookup 3

Top