Duplicate imported values in PK

[Ryan]

I am working on a new project to track medical records. The data I will be
working with will come from an imported file from a Linux database that will
be converted to an .xls file before import into the access database. My
issue is that my primary key will be the account number, and there will be
instances where the same account number will show up in later imports if the
account should have changes made to it. If this happens I would like the
newest import to overwrite any information from previous imports. There will
be a data entry table that will relate to the account number that needs to
stay as well, so I'm not sure if this is possible since the relationship is
based on the record set. Any suggestions or ideas will be a great help.
Thanks in advance...

 

[Jeff Boyce]

Ryan

So it sounds like you have two categories of "updates"...

If your import has an account number that matches an exsiting account number
in your Access database, you want to update that account's information.
This sounds like an Update query, matching input data records to existing
account records.

If you import has an account number that does NOT match an existing account,
you want to add the (new) record. This sounds like an Append query.

Regards

Jeff Boyce
Microsoft Office/Access MVP