Mutiple Tables - Append

[ranbir parmar]

How do I append multiple tables (30 or so) into a single
table (assuming all have similar fields)?

Thanks

 

[Ian]

-----Original Message-----
How do I append multiple tables (30 or so) into a single
table (assuming all have similar fields)?

Thanks
.

Look at append query type.

If you want you can make a select query first to make
sure your get the right records and amend it to an append
query. It will ask you which table you wish to append to
and which fields append to which table fields.

Need any more help just ask.

Regards

Ian

 

[Guest]

-----Original Message-----

Look at append query type.

If you want you can make a select query first to make
sure your get the right records and amend it to an append
query. It will ask you which table you wish to append to
and which fields append to which table fields.

Need any more help just ask.

Regards

Ian
.
Ian,

Thanks a lot for your help. However, Append Query allows
records from one table to be appended at a time. I was
wondering if there is a quick way merging (records of) all
30-40 tables in a single step.

Regards

 

[John Spencer (MVP)]

Not that I can think of. Other than you might me able to use a UNION query as
the source, but with that many tables involved, you may run into a problem with
a UNION query being able to handle all the tables.