use this...
insert into Table1
select distinct Kundennummer,Anrede,Name,Vorname,Zusatz,Strasse,Ort,[Telefon 1],[Telefon 2],
Fax,Natel,[E-Mail],Geburtstag,1
from table2
WHERE not exists (select * from Table1
where Table1.KndNr = table2.Kundennummer)
Note: when select records mention columns in order in which the destination table have
Happy Coding!
:)