Excel link to Access query not bringing back any data
I have linked an Excel spreadsheet to an Access query, and it does not bring back any data. See attached example. I have tried to bring the data in as a table and as a pivot table, but with no luck. Running the query in Access brings in multiple rows.
I am using Access 2016 and Excel 2016. Any ideas on what is going on here? Thanks. - Tom