Link to excel table which has keys in both row and col headers: is this possible?
2 views
Skip to first unread message
AC
unread,
Feb 6, 2013, 4:10:43 PM2/6/13
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Sign in to report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
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 :)