I guess I'm probably underthinking this, because I'm no S.Q.L. expert but here's how I would approach this (the first part):

Insert Into [Table1] (field1,field2.....) select distinct (field1,field2....) from [Table2] where...