matching tables

[Lisa]

Thank you in advance …..Any help would be greatly appreciated. I have two
tables, Table one is an “Import Table†(this table is imported and can not
be modified) I did a make table query which is Table 2 (an exact match)
“Update
Table†(this table will be modified with updates). What I am trying to do is
match
one to the other and tell me what the difference is in another Query or
Table. I have over 100 columns to match up. I assume this is possible but
I'm not an advanced user so any help would be greatly appreciated .... See
below….

Table 1 “Import Tableâ€
Site Col1 col2 col3
123 1/1/07 1/1/07 1/1/07
234 1/1/07 1/1/07 1/1/07
543 1/1/07 1/1/07 1/1/07

Table 1 "Update Table"
Site Col1 col2 col3
123 1/2/07 1/1/07 1/2/07
234 1/1/07 1/4/07 1/1/07
543 1/3/07 1/1/07 1/1/07

New Queries
Site Col1 col2 col3
123 1/2/07 1/2/07
234 1/4/07
543 1/3/07