Transfer records from one table to another ?

[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.

 

[SpookiePower]

I have tried this, but it does not work -

insert into table1 (data)
values (table2.data)

 

[KARL DEWEY]

INSERT INTO [table2]
SELECT [table1].*
FROM [table1];

 

[John Spencer]

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