I have two table which have exactly the same tavle structure. I want to append data in one table using data from another table. So far I have implemented this using a loop but it is a very lengthy process. Is there a better way of doing it?

I'm using VB6 and MS Access 2000