Merging 2 databases to 1

[clubinski]

Hello all,

I was reading some past posts on this site about doing this but my situation is a little bit different. I have 3 different databases some with the same queries and data but not all is the same. Can anyone help me out at least on where to go to learn how to do it ?

Thanks,
Chris L

 

[DavidAtWork]

Your post is very vague but generally if you're talking merging databases you mean merging recordsets. To do this I would work from what you would deem to be the main database you intend to keep and import tables from the other 2 databases and run a series of append queries to add any new records, or update queries if the data needs to be updated.
Other objects such as forms, reports or queries can be imported but may require some work to get them functional.

David

 

[clubinski]

David,

I do apologize for my post , thank you and I will give it a try!


Chris