Access pivot table to excel

Posted on 2009-04-21
Last Modified: 2013-11-28
I am running a few pivot tables in Access, and I was wondering if there is a vba code to allow these reports to be pushed into an excel sheet?  

I know there's a way to create a new file, and have it exported some what through a button located at top, but i'm looking to transfer exactly what the report shows, and would like to "append" to an existing file to a specific cell.

Any suggestions?  Thanks!
Question by:iamnamja
    LVL 74

    Accepted Solution


    I have seen this question asked on at least two occasions.

    The short answer is No, if your goal is to take an Access Pivot Table and simply bring it into Excel.

    The standard procedure is to Link the Access Data into Excel, then create your pivot table in Excel from this data.




    Author Comment


    To be honest, i saw this answer too =)
    But I guess I was kind of hoping that there's a better solution to all this.
    Thanks for confirming!
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now