I imported an Excel file into a Table (Table NS) in Access to compare to existing data (Table1). I have 98 records which exist in BOTH the new Table and the existing Table. However, when joined by the common field, the Query returns ALL 98 but only 2 records show data from Table1. The remaining 96 show blank values (these records and corresponding data do exist in Table1).
I checked and rechecked the joined field values and they ARE the same. Both fields are short text.
What can possibly cause this apparent syntax error for the "invisible" 96 records?