Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Query to Write to an Excel Pivot Table
- Thread starter mje397
- Start date
You can write a query in Excel that would access the data from Access and have your pivot table based directly on that. When you create your pivot table, choose to pull the data from an Exteral Data Source. And then it will walk you through the process of setting up the query.
- Status
Similar threads
- Locked
- Question
- Locked
- Question