append many tables to 1

[Denjuan]

I have 72 tables all the same structure. I want to put them all in one table. How can i do it without making 72 append queries?

Thanx already,

Denjuan

 

[The_Doc_Man]

Given that this is probably a one-time operation, it would be easier to make 72 append queries than to try to do this programmatically. However, the ease of the operation depends on how you were planning to do this.

Consider, if you will, designing ONE such query. Save it. Execute it. Now open it in SQL design mode. You will note that the source table name appears in clear text. Still in SQL Design mode, change the name of the table to the next one in sequence. Save it. Execute your query. Go back into SQL design mode ...... repeat as needed.

Now, if you were going to do this EVERY DAY, the answer is different. But for a one-time operation, it would take you longer to write the code than it would to just do it.