Table Linked To Access Query Does Not Display Anything

Hi all,

Using Excel 2013.

I used the Wizard to connect to a query in an Access Database.
A Table was created in Excel, and when I check Properties >> Connections everything appears to be correct
However, there is nothing in the Excel Table, not even the Header Row.

I checked the query in Access, it returns about 17K records.

Any ideas?

thx
w

What is the SQL statement used in the Access Query? Sometimes Excel has difficulty recognizing some Access functions so it would help to see your SQL statement.

Thanks Alan

Please Login or Register  to view this content.

I see nothing unusual in the SQL statement. I recall having a similar issue and once I went to the Data Tab on the Ribbon and clicked on Data-->Refresh All, the data populated the Excel spreadsheet. Try that and see if it works for you.