Import same data from 2 tables into one.

[voidcranium]

I have 2 tables that contain the exact same columns.
Basically titles and singers of CD's I have
I want to make one table out of them.

Is there a way to do this?

 

[voidcranium]

I found this article.
Think it might work?
ACC2000: How to Update and Append Records in One Update Query

 

[neileg]

If there are no overlaps in the data between the two tables, then just use an append query to add the records of one table to the other.

 

[GaryPanic]

make a copy first -in case it goes tits up .