Can two similar data bases be made into one?

[Guest]

New to Access. Two distant work areas created databases. Similar, but not
identical format. Would like to merge data bases. No luck with linking, or
relationships. Using Office 2000. Have MS Press "Access 2002, Plain and
Simple" for guidance. Either misreading or unable to comprehend. Would
appreciate guidance. Thanks.

 

[AlCamp]

Tucker,
Basically, you could do an Append query. When you append the records
from one table to another, you are asked the "From" field and the "To"
field. (ex. [St] in one table to [State] in the other)
So if the tables are similar, the Append should do the trick.
hth
Al Camp