Combining or merging 2 databases

[holding1]

Hi there.

Somebody has been inputing data into an old backup database instead of
the current one. What is the easiest way to move or merge that data
into the current one?

H1

[Arno R]

H1
If the problem concernes only 'new inputted' data it is easy:
I would link the tables from the old backup database and construct some append-querys.
When you have decent primary keys you can't even duplicate any data this way (not even if you try to
append all the records)

If 'modified existing' data is concerned than it is also doable, but much more difficult.
You would have to 'walk' the records and fields one by one then, and compare the values.
Let us know if this is the case and we will try to help on that.

--
Hope this helps
Arno R
<ho******@myway.com> schreef in bericht
news:10**********************@h37g2000oda.googlegr oups.com...

Hi there.

Somebody has been inputing data into an old backup database instead of
the current one. What is the easiest way to move or merge that data
into the current one?

H1

[Pieter Linden]

ho******@myway.com wrote in message news:<10**********************@h37g2000oda.googleg roups.com>...

Hi there.

Somebody has been inputing data into an old backup database instead of
the current one. What is the easiest way to move or merge that data
into the current one?

H1

Depends on how complex the database is. You could just import the
data, but if you have autonumber primary keys, it could cause serious
problems. You might want to look at this:

http://amazecreations.com/datafast/S...emerge2dbs.asp