I meant that you could create the pivot table in Excel, directly from
the data in Access --

In Excel, choose DataPivotTable and PivotChart Report
In step 1 of the Pivot Wizard, select 'External Data Source'
In step 2, click Get Data, and select your Access file
Then, complete the steps of the Wizard to build the pivot table


ken2005 wrote:
Thanks fellas for the help. Just want to confirm that. I guess I have no
other choice but to split the records into two worksheet.

Debra, I tried using the Pivot wizard in Access to do the job but there
is an error! Anyway, I need some mathematic functions in Excel to get
the job down thats why I choose to bring over the data from Access.

I try to retrieve data in Excel with:- Data - Get External Data -
Create New Query. However Excel doesn't split the records into two
worksheet when it is overloaded in the first worksheet. It prompts a
window that I have save it in the pics as attached.

Is there any other way to go about splitting the 120,000 records into
two worksheet?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html