Archiving Data

[PiedPiper70]

I'm trying to create an archiving routine as my database is becoming very large. For about 10 tables I want to shift certain records to an external database which would have the required 10 tables with the same table names and structure.

So far so good. I now want to automate everything using vba. I can see how to use the INSERT INTO statement but I don't want to have to name every field as there are hundreds. I just can't see how to do this.

So can someone please help me with my senior moment! If the table structures are identical how do I neatly shift a bunch of records from one to the other using code

Thanks
Dave

 

[PiedPiper70]

Doh. Self-solved. Just use asterisk to select all fields.