CSV file to overwrite selected fields in Access 97

[ALF Scot]

I have a database on my web site that collects address info, but the Access
database on my computer that I use as my master DB contains those fields and
a host of other tracking information. I can get the info from my web site in
csv format. How do I import the most current data (the csv file) and map it
so the correct fields for each record overwrites the old data in the Access
database, without harming the data in the additional fields only found in my
master database?

I am not a programmer, so I'm looking for the easiest, simplest way
possible. THANKS!

 

[Joe Fallon]

This is not very simple to do at all.
I built a whole application around this idea.

One idea would be to import the csv data to a staging table named "NewData"
or something like that.
Then write an Update query to move the data over to the real table and
overwrite the fields that match the key values.