solution for updating table based on data from another table

Posted by I__ on Stack Overflow See other posts from Stack Overflow or by I__
Published on 2010-06-07T19:24:59Z Indexed on 2010/06/07 20:02 UTC
Read the original article Hit count: 201

Filed under:
|
|

i have 2 tables in access

this is what i need:

1. if the PK from table1 exists in table2, then delete the entire record with that PK from table2 and add the entire record from table1 into table2
2. if the PK does not exist then add the record

i need help with both the sql statement and the VBA

i guess the VBA should be a loop, going through every record in table1. inside the loop i should have the select statement

© Stack Overflow or respective owner

Related posts about sql

Related posts about ms-access