Ooh append queries, it's been a while since I've done one of those...
My suggestion would be to look at using an SQL INSERT statement (which is what an append query is ) via VBA.
Here's a nice link for you http://www.w3schools.com/sql/sql_insert.asp
Have a go with that and let me know how you get on!
Ooh, before I forget, you want to use DoCmd.RunSQL in VBA to run your SQL statement!