How to pull values from Excel to MS Access?

[Jane Doe]

Hello

I have a spreadsheet that was nicely formatted by a user whose values I need
to incorporate in one of my MS Access reports.

Here is a sample layout of the excel file:

COLUMNS A B C D E
row 5 REGION 1 4000 5000 6000 7000 8000
row 7 REGION 2 100 200 300 400 500
row 9 REGION 3 800 700 600 500 900

row 12 REGION 4 55000 40000 36000 77000 88000
row 16 REGION 5 2500 1400 1700 1000 1500
row 20 REGION 6 9800 8700 7600 6500 1900

I am unable to import into MS Access because the excel file have several
headers from rows 1 to 4. And in between the region are additional titles.
Is it possible to lookup values instead of importing them?

TIA!

 

[Erik Veldkamp]

In Access, with File | Get external data | Link Tables you can select the
Excel type of file, amd therein either a worksheet or a named range.

Erik