If you are trying to append several tables together, try this:

In the Get Data phase of the Pivot Table process:
1)Select any one table from the MS Access database.
2)At the end of the process opt to Edit the Query
3)Click the SQL button
4)Rework the SQL code to return the fields you want from each table by using
the UNION ALL statement.

In my testing, I had copied and renamed the same table in a financial
application that I built some time ago: LU_ExpAcct== LU_ExpAcct1, LU_ExpAcct2
(I used 2 tables, but this works for any number of similar tables)

This is the structure of the SQL code for combining multiple tables:

SELECT Account, Name, RefNum
FROM (
SELECT LU_ExpAcct1.Exp_AcctNum as Account, LU_ExpAcct1.Exp_ShortName as
Name, LU_ExpAcct1.ID as RefNum
FROM `C:\Excel Stuff\Sandbox`.LU_ExpAcct1 LU_ExpAcct1
UNION ALL
SELECT LU_ExpAcct2.Exp_AcctNum as Account, LU_ExpAcct2.Exp_ShortName as
Name, LU_ExpAcct2.ID as RefNum
FROM `C:\Excel Stuff\Sandbox`.LU_ExpAcct2 LU_ExpAcct2
) as Combo

Return the data, to Excel and your pivot should contain the selected fields
from the combined tables.

Does that help?
--
Regards,
Ron