I have an Access database which has three linked tables from Excel as Input Sources. There are some queries that combine the data and I have two queries that are my outputs.
My intention is to have an Excel workbook that connects to the Access queries as data tables in Excel. One of my output worksheets successfully finds a Select Query in Access and returns the records into Excel. The other worksheet does not.
I'm trying to connect the other worksheet to a Subtotal Query in Access via the Get Data wizard Get Data>From Database>Microsoft Access Database and then connect to the aggregate query in Access but the query returns no records, even though the query has records in Access. Even in the Excel preview wizard there appear to be no records. I did get it to work using the old method: Get Data>From Other Sources>From Microsoft Query>Choose Data Source>MS Access Database and then browsing to the subtotal query and connecting to it.
Does anyone understand why the old method works but the new Get Data dialog doesn't when connecting to a subtotal query in Access?