How do I merge Tables in Access from different files?

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

 

[Jeff Boyce]

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

 

[Guest]

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

 

[Jeff Boyce]

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