Solved

Access 2003 table as source for EXCEL 2010 Pivot Table

Posted on 2014-01-28
1
442 Views
Last Modified: 2014-02-13
I have an access 2003 table and would like the table to be the source for an EXCEL Pivot.  Now I am appending the data from the access 2003 table to the EXCEL 2010 workbook.

Thoughts?  THANKS
0
Comment
Question by:eyes59
1 Comment
 
LVL 35

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39816166
I don't see a problem using an .mdb as the source.  What problem are you having?
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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