Pivot Tables - how do you export the results

[colezpapa3]

I am trying out the pivot table in Access....I have the report the way I want it but how do you export the results into Excel, when I do I get a message that Excel has different features in its pivot table ....

 

[dhookom]

Is there a reason why you don't just create the pivot in Excel rather than creating in Access and attempting to export it to Excel?

I much prefer working with Excel Pivot tables.

Duane
Hook'D on Access
MS Access MVP

 

[colezpapa3]

Well that is exactly how I ended up. They are better. I cut and pasted the query results into a blank sheet and ran the wizard. Worked well.

 

[dhookom]

You can also use msquery to pull the data from Access into an Excel worksheet.

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

I'm with Duane: it's often better to pull data instead of push them.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886