>INSERT INTO Table1 (field list here); >SELECT field list here; >FROM Cursor1; >LEFT JOIN Table1 ON Table1.Student_Number = Cursor1.Student_Number; >WHERE Table1.Student_Number IS NULL >I'm a little mechanical in my approach but I would query the cursor into a "final" cursor for the append, thus eliminating the items I did not want.