J
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!
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!