Update and/or Append one table from another!

[Krell48]

I have a database where I extract data from two sources, merge the data for use by another program. The merged data is stored in a "working" table. I then need to either append or update another table for export. This table has a double key. I am looking for an easy way to update those where the double key already exists or add if they dont.

Any suggestions. Thanks.

 

[cghoga]

i think if in your working table you do not allow duplicates
in your key fields (Indexed: Yes(No Duplicates), when you run your append query, if you setwarnings = false
it will only add the "new" records.

if your working table is static this should work. if it's built on the fly that's another story.

i hope this helps.

 

[Krell48]

I may have mispoke. From my working table I will most likey have to both update and append. Somehow I need to test if record exists, if so update. If record doesn't exist I will need to add. I am looking for an approach.