Excel Pivottable using data in Access 2002

[Stan Dowiat]

I have been using Access 2000 to hold tables with lots ( 200,000 rows ) of
data. In Access 2000 you can make a Pivottable Form which starts Excel and
really makes the pivottable there although the data actually stays in
Access. Works great.

I've recently gotten Access 2002 which tries to make the Pivottables itself.
It's not as good. I want this new verson of Access to work with Excel like
the old version. This new verson offers to let me "export" the pivottable,
but that tries to start Excel and copy the data in and there's too much data
for it to be able to do that.

Does anyone know how to overcome this problem? Maybe I'm overlooking
something. Thanks for any input.

 

[Ken Wright]

Have you tried creating the pivot table in Excel and simply querying the Access
database from there.

 

[Stan Dowiat]

Yes, and that does work, but the old way made it so easy o create a
Pivotable on the fly.