Re: merge databases

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


On a COPY of your database (or make a backup copy)
-- Open the "Master" Database in design view
-- Select File: Get External data: Import from the menu
-- In the File dialog, find and select the second database
-- Click Import
-- Select the objects you want to import. If there are duplicate names
between the source and the destination, the newly imported objects will
have a number appended to the name
-- Click on Options button and select the options you want there - such as
import relationships
-- Click the OK button

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"angie" <angie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D0ACD946-CC0A-46AD-8741-8CE5A74A7619@xxxxxxxxxxxxxxxx
i have two big databases and i want to create only one. can i merge
databases? i have tried to do this by copying each table, query, etc. is
there a faster way i could do that? moreover i would like to copy
relationships.

pls help me save valuable time!!!


.

Quantcast