Updating a Table

[bigbadbess24]

I have two tables. One table is linked to a text file that is always update by the another program. I have another table the is same exact one but it does not get updated.
I have access run these two tables to see the difference between. (Its basically and add/drop function) But after I run those two tables to see the difference, I want to update the nonlink file, so it is up to date with the "link" table. Thank you.

 

[neileg]

Is the unlinked table basically a snapshot of the linked table so you can see what has changed? You could run a delete query that deletes all the records in the unlinked table and then an append query to copy the data from the linked to the unlinked table.

 

[bigbadbess24]

Yes it is pretty much a snapshot of the linked table. So every time the linked table is updated I want to run it with the table is not linked to see what has been added and drop. After I see those changes I want the old table to be updated with the linked table.

I know what a delete query is but I am unsure of how to set it up along with append query.

Thank you

 

[bigbadbess24]

I figured it out. It was a lot easier then I thought it was. Thanks