same column name from multiple tables

C

ChuckTX

How can you (or can you) pull data from multiple tables that has the same
column name and stack the data.
Final column would be [table1 coulmn1 rows(X)] then [table2 column1
rows(X)]...
column1 would have the same name in each table.

Each table is a separate Excel but each file is exactly the same it's just
for a different case#. i.e. acct. code, desc., time, ...

I want to pull all of them to gether in to a table. I can create a
temporary table and do an update query on the temp table from each of the
other tables, I think.

Thanks, Chuck
 
O

Ofer Cohen

You can use a union query, such as

Select FieldName From TableName
Union
Select FieldName From TableName2
Union
Select FieldName From TableName3

That will stack the data from all tables, and will display it as one
 
Top