• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

Access pivot table to excel

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!
0
iamnamja
Asked:
iamnamja
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
iamnamja,

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.

;-)

JeffCoachman

0
 
iamnamjaAuthor Commented:
Boag,

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!
0
 
Jeffrey CoachmanCommented:
;-)
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now