Overwriting old duplicate

[Toan Chau]

Hello.

I have a database table in Access 97.

There are 5 fields in this table. Individually, these
fields can have the same vaules. But two of the fields
combined can not.

CSR and Daily_Date

So a record is considered a duplicate if the CSR field and
the Daily_Date field in one record matches the CSR and
Daily_Date in another record.

When I am importing a CSV file into my database I would
like for it to detect any duplicates based on the criteria
I mentioned above. And then I would like it to overwrite
that duplicate with the "newer" duplicate.

Is there an option to do this in Access?

Thanks!

 

[Joe Fallon]

Not a 1 step option.

Just import to a staging table and then run queries on it and only load new
data to the real table.

Do it by hand first and then program each step.

Use TransferText to import and DoCmd.RunQuery to run the data load.