I'm trying to create a pivot table in Excel to display data from a query in the Access database.
I've created the query and it correctly displays the data. When I try to connect to the query
from Excel, the query does not display in the data connection wizard. All of the other queries
in the database are displayed except the one I just created.
Suggestions?