Merging two MS-Access databases

[Guest]

I am charged with the duty of merging two Access databases that have field
with different names. Can someone please give me instructions on how to
accomplish this task?


Thanks guys,

 

[John Vinson]

I am charged with the duty of merging two Access databases that have field
with different names. Can someone please give me instructions on how to
accomplish this task?


Thanks guys,

Well... that depends on the structure of the databases, whether there
is or may be duplicate data in the two, whether each database has one
table or thirty, and on many many other things!

You'll certainly be running one (or many) Append queries, which might
be enough right there... but without knowing more about the database
it's awfully hard to say.

John W. Vinson[MVP]