Insert Into/Append Qry

Topic

New Reply

Is there any way using the ‘Insert Into’ statement that will force the contents of an existing record to be overwritten? I have 2 tables – each keyed by social security number. If, for example, a persons address changes I want the change of address data to be applied in the target table – but since it already contains that SSN the Insert Only operation skips that record. Any ideas? Thanks in advance.

Reply | Quote

Replies

Rather than appending a new record, consider using an Update query to update the address fields in the target table.

Reply | Quote

Thanks – a combination of both the update query and append query will provide a valid solution to the task I’m trying to accomplish.

Reply | Quote