I need merge to like databases together

[Guest]

I have a current database and a history database. they want to merge the two
together is there an easy way or do I need to write an append query for each
table.

 

[Jeff Boyce]

Databases are, in MS Access parlance, the entire file (all tables, queries,
reports, code ...).

Are you asking about merging the data from two tables?

If the fields are the same, you could append from Table1 to Table2 (or vice
versa). What is it that you want to end up with?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

All the tables in one database have a copy in the other. the 2nd database was
a type of backup now they want all the data put back together into a single
table.

 

[Joseph Meehan]

All the tables in one database have a copy in the other. the 2nd
database was a type of backup now they want all the data put back
together into a single table.

Are there duplicates to be accounted for? If not (try this on a copy
first) link to the data table (one at a time) in the target database and
create an append query to append the data from the linked table to the
destination table.

 

[Jeff Boyce]

Les

I'm still confused.

"all the tables in one database have a copy in the other" and "all the data
put back ... into a single table"

If you have multiple tables of data, how are you proposing to ?denormalize?
that data structure and put it "all ... into a single table"?

If you are trying to copy all the records from Table1, DB1 into Table1, DB2,
and so on for each table (in both), you can do this by opening DB2, adding
links to the tables in DB1, and using an append query from Table1, DB1 to
Table1, DB2 (and so on...)

What am I missing?!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Larry Linson]

I have a current database and a history database.
they want to merge the two together is there an
easy way or do I need to write an append query
for each table.

Hunh? Who are "they"? Are the two databases of identical format? Why
would there be an advantage to "merging the two together" to a table to
store the data? If the databases are identical format, you should be able
to display and print them easily by creating a UNION or UNION ALL Query to
use as the RecordSource of the Form or Report.

Larry Linson
Microsoft Access MVP