I don't think it is possible, you can use multiple excel sheets/tables
(although a lot of the functionality gets lost) but not multiple access
tables.

--
Regards,

Peo Sjoblom


"fbj" wrote in message
...
Hi
I would like my pivot table to draw data from several tables in an Access
database. Although I have gone through the query wizard and added the
fields
from all the database tables, I still find that when Excel reads the data
into the pivot table it stops after the first table and I only get part of
the source data I am looking for.

What am I missing in order to consolidate the data from several tables?

with thanks.