Access databases

  • Thread starter Thread starter Anthony Deane
  • Start date Start date
A

Anthony Deane

Hello,

I have two (almost) identical database. (One was a backup copy that kept on
being added to at the same time as the first was in use)

I would like to merge the two of them together back into one database. Is
there a programme that could do this, rather then printing them both out and
going
through it manually. (Something that I wouldn't be too pleased to do).

Any help would be brilliant.

Anthony Deane
 
* Anthony Deane Wrote in alt.comp.freeware, on Fri, 5 Sep 2003 14:26:05 +0100:
Hello,
Click to expand...
I have two (almost) identical database. (One was a backup copy that kept on
being added to at the same time as the first was in use)
Click to expand...
I would like to merge the two of them together back into one database. Is
there a programme that could do this, rather then printing them both out and
going
through it manually. (Something that I wouldn't be too pleased to do).
Click to expand...
Any help would be brilliant.
Click to expand...
Anthony Deane
Click to expand...

The Query function within Access should allow you to create tables with
the results of a merge minus the duplicates. I don't know your skill set
in Access but this isn't really a tough task, it could actually be (dare
I geek out...) fun. The built in help might actually be able to guide
you through it or give a close example.

If you have access, I will assume that you also have Excel, worst case
you could export the tables into excel, sort and remove dups, and export
back to access.

Printing should certainly not be necessary.
 
Anthony Deane said:
Hello,

I have two (almost) identical database. (One was a backup copy that kept on
being added to at the same time as the first was in use)

I would like to merge the two of them together back into one database. Is
there a programme that could do this, rather then printing them both out and
going
through it manually. (Something that I wouldn't be too pleased to do).

Any help would be brilliant.

Anthony Deane
Click to expand...

I could have sworn I responded to this. Maybe that was the night my
PC crashed with lots of half done windows.

Any number of scripts/utilities for this purpose are just floating
around. Here's a generic ODBC one: DBComp. You might want to check
with Access news groups. You'll probably get many more responses.

Whether utilities like this are more than slightly useful depends on
what is out of sync. I've spent anywhere from a few hours to months
doing just this sort of thing. For example, as long as the users
haven't changed the meaning of codes or assigned the same customer
number to two different customers, then a reconciliation (diff and
merge) is easy. Any deviations make the effort progressively harder.

All important (unsolicited) advice - BACKUP EVERYTHING before starting
and work out the procedures in a TEST db.

DBComp
http://www.funduc.com/dbcomp.htm

Good luck,
BillR

-----
(From the site)
DBComp, one of our freeware products, is a database comparison and
merge application. The program performs two basic tasks:

1) The Compare Data Sources function compares two OBDC data sources
for alike vs. different records and generate a Difference File that
lists the records that either do not match or have been added/deleted
from one data source compared to the other.

2) The Merge function examines a Difference File generated by DBComp
and updates the specified data source via SQL statements. You can view
the SQL statements in advance and remove one (or more) in advance if
you wish.
 
Back
Top