View Full Version : Import same data from 2 tables into one.


voidcranium
02-01-2007, 12:52 PM
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
02-01-2007, 01:55 PM
I found this article.
Think it might work?
ACC2000: How to Update and Append Records in One Update Query (http://support.microsoft.com/?kbid=208870)

neileg
02-05-2007, 07:47 AM
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
02-05-2007, 08:29 AM
make a copy first -in case it goes tits up .