Merging 2 different access databases ??

[iamwhatiam]

How can I merge 2 different access databases ???

I need to manually match different fields to merge.

Or is there a program available that can do it.

The closest I have got, is to export one database as a CSV, and then
import it into the other database. But it does not let me say which
fields in the source database match which fields in the target
database. I thus get error message saying that some fields are
incompatible.

 

[Rick B]

If it were me, I'd link the tables from one database in the other. I'd then
build update and append queries to copy data from one table to the other.
I'd then delete the links and delete the original duplicate database.

Before doing any of this, I'd make at least one good backup of each file.

 

[iamwhatiam]

Tried append queries, but I keep getting 'type conversion failure'
when trying to run the query.

I've only selected one field to append, and I've also checked to make
sure both source and destination database field types are the same. I
still get 'type conversion failure'.

It also tells me in the error message that there 18063 records will be
updated. The source database has only 81 records and the destination
database has only 223 records.

 

[jojo]

good morning

If it were me, I'd link the tables from one database in the other. I'd then
build update and append queries to copy data from one table to the other.
I'd then delete the links and delete the original duplicate database.

Before doing any of this, I'd make at least one good backup of each file.

 

[Guest]

I don't understand this either. I tried highlighting one database, copying
it, and pasting it into the other one, but the "paste" option was gray so I
couldn't do that. How do you link databases? One is on our shared drive and
one is on someone else's computer.