Import Excel anomaly
When importing from Excel, I choose Add New Records and Update Existing Records in Found Set.
But for some reason it deletes all existing records that are not in the table being imported.
Should it not simply leave existing records alone completely, and add any new records from Excel ??