I am appending a query to a table. The question I have is can you replace the old data in the table with the new data from the query without having to go into the table and delete the old data? Right now if you click append twice it will just keep adding the same information. I want it to overwrite the old info in the table.
Do you update the data in the database by any other method except the spreadsheet? If the answer is yes, then how do you propose to determine which version of the record, field by field, is current?