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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Table and Subtable in RDLC 5
Report, Shrink, hiding blank lines 3
Change columns into individual records 1
CrossTab Query with Min 3
Merge two files based on one column 1
Import Text File 2
Union Issue 3
Query multiple table relationships subquery? 1

Back
Top