same column name from multiple tables

[Guest]

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

 

[Guest]

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

 

[Jeff Boyce]

That's how I'd approach it. Append each of your Excel records to a
well-normalized Access table structure, then use Access queries on that
data.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/