Unless you just want to learn how to do it with a Macro or VBA it is easier run an Append or Update Query.