It'd be nice to have a filemaker equivalent of a UNION type SQL query.
One approach I can think of is to
- import the records into the same table.
- Enter find mode and enter an ! into the name field to find duplicates
- Select the Omit option to omit all duplicates (There'll be a duplicate entry for every record that is in both spread sheets).
- Perform the find.
Generally speaking, simple queries are much simpler to do in FileMaker than Access, but as you set out to perform increasingly sophisticated queries, the pendulum gradually swings the other way in favor fo the greater power of a decently crafted SQL query.