Update Records in a Table

[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

 

[Douglas J. Steele]

Check my November, 2003 "Access Answers" column in Pinnacle Publication's
"Smart Access".

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html