Appending multiple tables

G

Guest

I have taken on a new role where I have control of 7
databases on different sites. I want to create master
tables with data from each database. Is there a way I can
append all the tables into the master table at one go
rather than appending them one by one?

Many thanks

GLS
 
Top