I have two tables that both come from an Excel import. Call them yesterday's import and today's import. The two tables have exactly the same structure as far as field names are concerned. But I need to find a way to identify the differences between the two tables as far a field values go. Also I need to know if a record was deleted from yesterday's table or if a record was added to today's table. Make sense?
How can I do this?