Append / Update Query Question?

[Marbinski]

I am appending data from one table to another. I was wondering once I use an append query to transfer data from TABLE1 to TABLE2, is TABLE2's data already updated?

Are append queries the same as an update?? Basically I just want to ensure my data is saved into the table safely.

Thanks for any input.

 

[rpshi]

I have a similar problem.
But I want to make a "conditional query". When the entry is already in the table, I want to make it an update query. And when it's not, it can be appended to the table. How can I do that?
Thank you!

 

[KenHigg]

I was wondering once I use an append query to transfer data from TABLE1 to TABLE2, is TABLE2's data already updated?

?!?!?

Append queries appends new rows or records, update lets you update the flds in an existing row or record.

kh