Share via

pivot table from access query

Anonymous
2013-03-14T18:02:38+00:00

I am wondering if it is possible (and how) to create a pivot table based on an ms access query.

Presently I have been exporting the query as csv and then running a macro to create my pivot table.

I attempted to choose an mdb as a datasource but after doing so I'm not presented with a list of queries to pick from like I was expecting.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.9K Reputation points Volunteer Moderator
    2013-03-14T23:12:48+00:00

    Hi,

    Try to fetch data from the Access query by going to Data > From Other Sources > From Microsoft Query > MS Access Database

    Hope this helps.

    Was this answer helpful?

    0 comments