That is one of the real advantages of pivot tables is that they can link
directly to databases which gets you around that pesky 65,536 rows limit. It
is easy to do. Start your pivot table as normal but when you get to the
section on Data Source (Step 1) change the option button to External Data.
Choose Get Data. From there you can select Access and then browse for the
database you want. At that point you select either the table or query that
you need and you are good to go...

Your only limit is memory so you can easily bring back a couple of hundred
thousand records (millions even) and the preformance is surprisingly good...
--
HTH...

Jim Thomlinson


"Little Penny" wrote:

Is it possible to have a Pivot table in Excel use a table in an Access
Database as it source data?

If so can some one point me in the direction that can teach me how to
set this up.