We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

access 2007 pivot export

pgmtkl
pgmtkl asked
on
Medium Priority
300 Views
Last Modified: 2012-05-11
I have a query that i created a pivot table on and it displays the data as i need it. When i export to excel the formatting is lost. Is there a way to export an access query as a pivot table to excel or pdf? Can i code a macro that will do this?
Comment
Watch Question

LucasMS Dynamics Developer
CERTIFIED EXPERT

Commented:
What if you exported only the data to your excel file that would generate your pivot table instead?

Author

Commented:
When i try exporting to excel it is counting the data instead of displaying the detail as access does. The format in access is exactly what i need. When i use the export to excel button at the top it exports 2 sheets- one with the raw data and one that is trying to count.
LucasMS Dynamics Developer
CERTIFIED EXPERT

Commented:
What if you exported your report using Snap shot viewer instead?

Author

Commented:
Where is the snapshot viewer? Is that an add-in?
LucasMS Dynamics Developer
CERTIFIED EXPERT

Commented:
in case you haven't found it here it is:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b73df33f-6d74-423d-8274-8b7e6313edfb

then just export your report to a .SNP like

DoCmd.OutPutTo acOutputReport,"name of the access report", _
acFormatSNP, "name of the snapshot file", True

Author

Commented:
The snapshot isnt working. When i try to export my query to excel it is trying to count my data. I need it to read with the descriptions in the pivot table
LucasMS Dynamics Developer
CERTIFIED EXPERT

Commented:
are you getting an error with snapshot viewer?  
MS Dynamics Developer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.