basic question that I should know

R

RobertM

Hello:

I have a database that I need to load repititious data into. What I need to
have happen is that when an updated record is loaded in by the
transferspreadsheet macro with a status that has changed from 'Captured" to
"Authorized" I need to have the record replaced with the one with the
"Authorized" status.

This seems like it should be a very basic question, but I'm having some
serious writers block with this.

Robert
 
S

Scottgem

Assuming the spreadsheet contains the key value, you need to run two
queries after importing. First an Update query that joins the input
records to the existing table and updates what's in the input. Then run
an Append query to add the new records. The append query will ignore any
existing records (where the key field matches). the Update query will
ignore any new records since they haven't been added yet.

HTH
Scott<>
Microsoft Access MVP 2007
 
Top