Access query not showing up in Excel - Help please

Question

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.

Answer 1

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.

Answer 2

Is the query parameterized in Access? If so, it's not going to show up in Excel.

====

This would be true whether the query is directly parameterized or whether it is based on a parameterized subquery. Excel can't resolve those parameter references and doesn't try.

Answer 3

No, there are no parameters in the crosstab query or the query the crosstab query is based on.

Answer 4

Are you able to connect to the “raw” data and then build your pivot/cross tab in Excel?

Answer 5

Hi Who_Am_I_anyway?：

Thank you very much for your feedback, I did the same test in ours and the same problem occurred.

I have created a crosstab in Access：

But when Excel imports data from database, crosstab does not appear：

I think the reason should be that the crosstab data is a query generated from raw data, so Excel doesn't recognize it. I am very sorry for the inconvenience caused to you. But I also found a compromise for you, maybe you can also cross-tab query the imported data in Excel.

You can create a pivot table from the table you import, Then generate a cross query by setting rows and columns. For detailed steps and references, you can also refer to this document ：How to Create a Crosstab in Excel (Step-by-Step) - Statology

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

The picture below is a simple test I did, I hope it can help you：

At the same time, we are very sorry for not being able to import the cross-reference table directly from Access, we fully understand that this brings a lot of inconvenience to your work. We also recommend that you can directly submit your feedback in the Excel application, and your feedback will be sent directly to the developers of the program, which will help to fix this problem efficiently. More information for you to reference: How do I give feedback on Microsoft Office?

Hope this will help you,

Tin