Merging 2 Access databases

[abprules]

If I wanted to merge 2 sample databases that are from the same Access
version, such as an events management and a scheduling database, is
this possible? And if so, can anyone give me directions or give me a
page that has the directions?

[abprules]

Re: Merging 2 Access databases

FYI, the databases are sample databases so the data in them is not
really valid. I only want to avoid creating the structure and tables
from one database into the other, if possible.?? Any help??


abprules wrote:

If I wanted to merge 2 sample databases that are from the same Access
version, such as an events management and a scheduling database, is
this possible? And if so, can anyone give me directions or give me a
page that has the directions?

[pietlinden@hotmail.com]

Re: Merging 2 Access databases

Just import all the objects into one of them.
File-->Get External Data-->Import--->FileType = Access and away you go.
just select everything.

[Larry Linson]

Re: Merging 2 Access databases

<pietlinden@hot mail.comwrote

Just import all the objects into one of them.
File-->Get External Data-->Import--->FileType = Access
and away you go. just select everything.

I'd suggest importing all the objects from one of them into a _copy_ of the
other, to leave the originals intact... just in case.

Larry Linson
Microsoft Access MVP