Hi Dan,
I have an excel spreadsheet which contains several pivot
tables. I would like to to create an Access database and
link a table to each pivot table. Does anyone know if
this is possible?
I'm not sure I understand what you mean by "link a table to each pivot
table." Jargon Alert: in database lingo, to "link" means to establish a
connection to data from another application so that you can view and
edit the data in both the original application and in Access. A
relationship between database objects (tables and/or queries) in order
to bring data together is called a "join."
You can _link_ to a worksheet or named cell range containing a pivot
table (File | Get External Data | Link). Then you can use the linked
spreadsheet just as you would an Access table, including joining it to
other database objects, whether creating joins in the Relationship
window and/or ad hoc joins in the QBE window.
Hope this helps,
LeAnne
