Consolidating Multiple tables to One Table

[Guest]

Hi, I have 50 files that i have read in to 50 tables from an external
location --
They are all of the same following structure

TABLENAME_YYYMMDD_HHMNSS
column1 Date ,column2 Date ,column3 TEXT ,column4 LONG ,column5 LONG
,column6 LONG

The question is
I would like to get all of the data in these tables and put into one table
called TABLENAMECONSOLIDATION

i have searched and searched for a script that can do this to no avail, and
i have tried writing code to do this using various methods but its just not
happening.

can anybody help please.

 

[Guest]

Create an Append query using the first table to your TABLENAMECONSOLIDATION.

Then open the query in desin view, click on menu VIEW - SQL view. Edit the
FROM to the second table. Run. Repeat for all the rest of the 50.