Append Query for Changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a csv file which I downloaded and imported into an Access 2003 table
using one field Participant ID that NO duplicates are allowed. This field
will remain the same for every download.

But after the initial import is complete I need to be able to APPEND only
changes made to my records, i.e. telephone number change or company name
added or add any new records that were created in my CSV.

I thought an append query would be the best solution. Am I right? And if
so, how do I create an append query that will only import records that have
changes made to them or are newly created?

Thanks in advance!
 
An Append query adds records to the table, it does not update the records.
You must do an update query and base the update on the primary key. Your
easiest method would be to import the csv into a temp table and then use the
temp table to match field for field to update your main table.
 
Back
Top