Try looking at the code here:

http://www.vb-world.net/articles/database3/index4.html

It is code to create a new database, but it will give you an idea of how to go about what you need to do. There's a good example of the 'append' with DAO.

smh