i have two ms access table ( TableA & TableB) .. how i can copy from TableB to TableA..Avoid duplicate records My code below Insert into TableA (slno,name) select slno,name from TableB
duplicate slno copy to TableA…. How i can stop?