Appending Table from one Access file to another. 1

[KrazyKT]

Help.&nbsp;&nbsp;I know how to create append queries in order to append one table in one mdb file to another.&nbsp;&nbsp;I have a large quantity of tables&nbsp;&nbsp;that need to be appended into one table.&nbsp;&nbsp;Is there anyway to speed this process up?&nbsp;&nbsp;Thanks for the help.<br><br>KrazyKT

 

[JimHorton]

If all of the tables have the exact same fields, then yes, this can be automated easily by looping throught the tabledefs collection using (pseudo-sql) 'insert into destination select * from td.name&quot;.&nbsp;&nbsp;If they have similiar fields, ie compatible types but not necessarily the same field names, a union query can be used, the sql for this can be generated via the tabledefs collection also.<br>--Jim