I need to update a database of archaeological features by totally overwriting the existing data with a new dataset. I have an attribute table associated to some points which is all of the data I want to appear in the new table. How do I effectively copy and paste this attribute table into the other table, removing all of the entries which already existed?
Also, how do I combine the two tables, so that entries which are contained within both are overwritten, new entries in the attribute table are added to the other and the original table retains all of the other features?
Thanks