software coding

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?