How to append 4 tables into one by a single query in Access 2007?

[katrina11]

Hi experts,

I need to append FOUR tables into one in Access 2007. Is there any way to do in by single query? Could you please help me with it?

Any help will be greatly appreciated!

Katrin

 

[Andrzejek]

Did you try:
[tt]
Select * from OldTable INTO NewTable[/tt]
?

Have fun.

---- Andy

 

[dhookom]

Is this a one time task or repeated regularly?

Are all four tables the exact same other than data?

Are you concerned about duplicate records?

Have you considered creating a union query of the four tables like:

SELECT Field1, Field2, Field3, ....
FROM tblA
UNION ALL
SELECT Field1, Field2, Field3, ....
FROM tblB
UNION ALL
SELECT Field1, Field2, Field3, ....
FROM tblC
UNION ALL
SELECT Field1, Field2, Field3, ....
FROM tblD;

You can then append from the union query into your other table.




Duane
Hook'D on Access
MS Access MVP