Jump to content

Merge two databases into one


RET
 Share

This topic is 7123 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have two databases one with the same names as the other database. I would like to merge database1 into database2, but I only have some of the fields in one and not the other.

Do I create the feilds first? Is there an easy way to do this? You see I also need record "John Smith" to stay in the same place.

Thanks,

RET

Link to comment
Share on other sites

It depends.

I'd suggest first deciding which database will remain. In this database create all the necessary fields -- make doubly sure the names are identical in both databases. Then perform the import by matching the field names.

Depending on what was in the databases, you might then need to search for duplicate records and delete the extras. Again depending, you may need to "merge" the data in the duplicate records before deleting the extras. No, there is no magic way of "merging" the field data (hence tyhe term in quotes) the most fool-proof way is to check them manually by eye and decide yourself.

Link to comment
Share on other sites

This topic is 7123 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

    1 member has viewed this topic:
    Backe11 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.