Update and Append data from temp table to permenant table

[smiley1978]

I have a temp table that I transfer an Excel spreadsheet into. I need to update an existing table in my database with the data in the temp table. I also need to Append any new records. I have an update query that updates the exisiting records, but it will not append any new ones, and I do not want to append all records as that will create duplicates and violate the Primary Key. Can this be done within one query or do I have to set up an Update Qry and then an Append Qry? If I have to do both, what is the best way to find all records on the temp table that have no matching records on the permenant table. Those are the only ones I want to append.

 

[MyBoo]

Run an Unmatched query between the two tables to find those you would append.... Quert/New/Unmatched.. you'll need to identify the key fields.

 

[MyBoo]

Typo... Query/New/Unmatched