I have an Excel table linked to an Access query, Microsoft Office 365 ProPlus. In the Access query I am eliminating certain records based on <> Criteria. The record count from the query is 62 records. When I refresh the Excel table, the record count is 75 records. The 13 different count is due to the <> Criteria in the Access query.
What am I missing here? Why is the Excel linked table bringing the records across that the Access query is eliminating? I'm just not getting it. Where might I be going wrong? Thanks. - Tom