Share via

Access query not showing up in Excel - Help please

Anonymous
2022-04-21T13:15:57+00:00

I am trying to use a crosstab query from Access in an Excel spreadsheet to build a pivot table. For some reason the crosstab query will not show up in the Excel navigator. Does anyone have any ideas why this is happening?

The image below shows the one query showing up but the crosstab is not.

Microsoft 365 and Office | Access | For business | 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
Answer accepted by question author
  1. Duane Hookom 26,595 Reputation points Volunteer Moderator
    2022-04-22T21:47:01+00:00

    I was able to create a new query that selected all the columns/fields from my crosstab. I was able to connect the new query (basically the crosstab) to Excel.

    1 person found this answer helpful.
    0 comments

7 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 22,300 Reputation points Volunteer Moderator
    2022-04-22T19:59:14+00:00

    Yes, I found that I was not able to link to a crosstab either, so the next approach needs to be pulling the data and manipulating as needed in Excel.

    0 comments
  2. George Hepworth 22,300 Reputation points Volunteer Moderator
    2022-04-22T22:51:02+00:00

    Brilliant, Duane.

    0 comments
  3. Anonymous
    2022-04-25T13:11:24+00:00

    YES!!!!!! This worked.

    Thanks you so much!!

    0 comments