Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot Tables - how do you export the results

Status
Not open for further replies.

colezpapa3

Programmer
Dec 8, 2007
73
US
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 ....
 
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
 
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.
 
I'm with Duane: it's often better to pull data instead of push them.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top