Hi, I a table in access. Sometimes when I do a mass upload, I can return some duplicate entries to what was already in the database. I know about append query to remove duplicates using primary keys.
My problem is, this append query will delete the newly uploaded data and keep the old stuff. I want to delete the old data and keep the new via the append query.
If there is another means to doing this, please let me know.
I don't mind overwriting old data with new data in the mass upload, but think this may get a bit too complex.
Please let me know if you need to know anything else to help me.
Thanks in advance!
Phonic
My problem is, this append query will delete the newly uploaded data and keep the old stuff. I want to delete the old data and keep the new via the append query.
If there is another means to doing this, please let me know.
I don't mind overwriting old data with new data in the mass upload, but think this may get a bit too complex.
Please let me know if you need to know anything else to help me.
Thanks in advance!
Phonic