Link to excel table which has keys in both row and col headers: isthis possible?

A

AC

Hi

I would like to link to an Excel table that is not formatted like the rest of the database tables.

In the other dbase tables we have it formatted something like:

name year <data>
unit1 2010 x
unit1 2011 y
unit1 2012 z
:


The excel data however has been formatted differently for easy reading, like:

2010 2011 2012 ...
unit1 x y z
:


Is it possible to link to this table and have access know that the unit names and the years are "key" fields? ie that 2010 2011 ... and not field headings?

If so, what are the terms I should be searching for when googling etc.

Im new to all this linking to Excel, so the more hand holding the better :)

Thanks
Andy C
 

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

X,Y,Z values to be extracted and posted respectively in excel 5
Gather multiple keyword and separate them to categories 2
Excel-Auto Sort and Paste to new Column 1
How do I Transfer Data from one table to another 6
Is it possible to intercept pivot table SSAS query or extend SSASprovider? 0
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Link 1 field in a table to a cell in Excel 2
linking a cell to multiple cells in another table 1

Top