Results 1 to 2 of 2
  1. #1
    graviz is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Sep 2009
    Posts
    48

    Export Access Pivot Table to Excel

    Does anyone know how to export an Access pivot table to Excel. I've used the docmd.transferspreadsheet in the past and it works great for raw query data, however I cannot figure out how to export the pivot table view in a query. Thanks!

  2. #2
    whphillips963 is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2009
    Posts
    1

    PivorExportToExcel

    I'm working on a similar problem. I've noticed that when I was designing my Access 2007 PivotTable, there was a button which exported the results to excel exactly as it appears in access - as a pivot.

    So far, the best I've found is a link that showed how to put that button in a customized ribbon menu. The button is called PivotExportToExcel. Not sure how it works in Access 2003.

    Here's an article that has the information I needed to figure out how to do it.

    http://www.databasedev.co.uk/access2007ribbon.html

    My problem now is that, I'm trying to deploy the solution and for some reason, this particular PivotExportToExcel item doesn't show up in the compiled version. Other items do.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. command button to export to excel
    By jains in forum Forms
    Replies: 5
    Last Post: 06-30-2015, 06:27 PM
  2. Replies: 0
    Last Post: 06-24-2009, 03:10 AM
  3. Export to Excel
    By vaikz in forum Import/Export Data
    Replies: 3
    Last Post: 03-25-2009, 09:37 AM
  4. Exporting pivot table
    By nesbtech in forum Import/Export Data
    Replies: 1
    Last Post: 04-28-2008, 12:19 PM
  5. Pivot Table Problem
    By larpup in forum Forms
    Replies: 0
    Last Post: 01-06-2006, 08:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums