Update Records in a Table

B

Brig

I have a table with a list of people. Each person have its own Unique ID
and is the primary key - no duplicate records should be created.

The table is imported from a csv file coming in from a client. The csv file
has the updates on them ranging from new address, telephone, effective date
or term date.

What I want to happen is that MS Access will REPLACE what is on the table if
it find a match and CREATE a new one if it can not find a match.

Is there a way to do this?

Thank you in advance.

Brig
 
Top