Mutiple Tables - Append

  • Thread starter Thread starter ranbir parmar
  • Start date Start date
R

ranbir parmar

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

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

Thanks
.
Click to expand...
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
 
-----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,
Click to expand...


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
 
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.
 
Back
Top