Hey everyone.. I have two tables, newTable and newTable2, I am trying to append newTable into newTable2.. They both have the same column names so I thought it would be cake.. If possible I would like it to remove duplicates also.. The code I have is
CurrentDb.Execute "INSERT INTO newTable2 " _ & "SELECT * " _ & "FROM newTable;"
I thought that would do the trick but I'm Making mock first names and they are not coming up in the newTable2.. Any ideas would be great.. Thankss