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!
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!