How to combine two microsoft access files into one?

[Guest]

My problem is how to combine or merge two microsoft access files into one
file? I'm preparing the fixed asset register for my company. I sent the fixd
asset register form to our branches. Now my job is to combine all the form
(softcopy) return by them into one file without overwriting each other
information.

Thanks for your help.

From: Joy

 

[John Vinson]

My problem is how to combine or merge two microsoft access files into one
file? I'm preparing the fixed asset register for my company. I sent the fixd
asset register form to our branches. Now my job is to combine all the form
(softcopy) return by them into one file without overwriting each other
information.

Thanks for your help.

From: Joy

This can be as simple as using File... Get External Data... Link and
running an Append query, or it can be very complex, depending on the
structure of your database. Do you have multiple linked tables? Do you
use Autonumber primary keys? (If so, you will have duplicate ID's
between the two databases which must be resolved). Since you don't say
what a "fixed asset register form" might be, or what information you
are storing or how, it's a bit difficult to advise specifically!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps