Transfer records from one table to another ?

  • Thread starter Thread starter SpookiePower
  • Start date Start date
S

SpookiePower

I have two exactly the same databases, and now I want to
join all the data/records into just one database. If I would
like to add all the data from one table to another, is it then
the INSERT INTO query that I shall use ?

I shall not overwrite records, just add the other records
from the other database.
 
I have tried this, but it does not work -

insert into table1 (data)
values (table2.data)
 
STEP 1: BACKUP your data before attempting the following.
STEP 2: BACKUP your data before attempting the following.

Without a backup you cannot restore the data if this does not work the way you
expect.

INSERT INTO Table1
SELECT * FROM Table2

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Back
Top