Can't you just write a regular append query and when you click a button have it do:
DoCmd.OpenQuery QueryName, acNormal, acEdit 'where QueryName is the name of your query
It would prompt the user to Append, but if you don't mind that, it 's a simple and fast way to do it.