Consolidating Multiple tables to One Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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