How do I merge Tables in Access from different files?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have different but similar tables from different files. I want to merge all
the information into one file. Though I have some different fields most of
them will match up. I may have a problem with some primary keys but I think I
can get by that. Both files have realtional tables but would be similar in
the two files I want to merge.
 
Dan

There's no magic bullet. If things don't match up, they don't.

You can open a new .mdb file and link to the various tables in the various
other databases.

Once you have all tables linked, you can create one/more new tables in this
new .mdb/database.

Use queries to append records from the "old" tables to the new one(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff, doesn't linking slow down any response time when you want to input new
data? Linking isn't the same as merging two separate tables... is it?
Dan
 
Dan

On the one hand, having to go out across a LAN to a server to get/put a
record could take more time than if the data were sitting on the same PC.

On the other hand, spending the time/effort thinking about the above offers
the chance to change from a design that has a form load ALL of the
underlying records to a form that loads NONE of the underlying records, and
only loads ONE record, after selection. That could be faster!

Speed of network, speed/duplex setting of NICs, speed of server, underlying
back-end data server (file server or client-server), etc. can all impact the
speed.

On the third hand, having your data reside on a network share means more
than one person can use it, and you can get the network folks to
automatically back it up, versus a single-user system that is only backed up
if the user remembers.

What kind of performance do you get when you test it?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top