Overwrite duplicate records from one table to another

[naitx]

hi,

I'm trying to Transfer all records from table A to table B and I would like to overwrite duplicate records from table B.

this code only transfer the record but not overwrite duplicate records.

cn.Execute "INSERT INTO B SELECT * FROM A'"

can someone show me how to do this?


Thanks in Advance

 

[Andrzejek]

You can try:

    [green]'PK is a Primary Key[/green]
Cn.Execute "DELETE from B WHERE B.PK IN " _
    & "(SELECT B.PK FROM A, B WHERE B.PK = A.PK) "
    [green]'We don't have any duplicates any more[/green]
Cn.Execute "INSERT INTO B SELECT * FROM A"

Have fun.

---- Andy