Combine Databases

  • Thread starter Thread starter Terry Watson
  • Start date Start date
T

Terry Watson

I need to combine 2 databases into 1. They both have some of the same
fields. Can this be done?
 
Terry

Not much to go on...

Open one. Use File | Get External ... | Link ... to link to the tables of
the other -- I assume you only want the tables because you mention "same
fields".

More specific description will probably lead to more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have a database called data.mdb. In it are 2 sub-databases, I have 2
tables that have 4 fields that exist in both I would like to combine the
tables into one so that I don't have to type in the same information twice.
Or, maybe link them together??
 
Terry

Did you try my earlier suggestion?

By the way, in Access parlance, there's only one "database" ... that's the
..mdb file itself. Each collection of related data is stored in Access
"tables" ... there's no object known as a "sub-database".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combine 2 database 7
Data Mismatch in Excel 2010 4
Combine data in two records from same field 16
Combine Tables in a Database 4
Combine two fields - retain formatting 7
Combining 2 Tables 4
combining rows of data 4
Combining 2 mdb databases 0

Back
Top