Importing tables

[Guest]

If I have a database that I created, can I import the tables and forms into
another Access database. How will this affect the database I imported the
tables into? The tables will not have any duplicate names. We have a database
offsite with patient data and I need to create a database that will enter all
the lab data for each patient. When all the lab data is entered we need to
add this information into the offsite database. I am using Access 2003.

Thanks in advance for your help.

 

[Kai Apel \(Berlin\)]

Did you know about Replication of your Database? Perhaps that´s, what you
are looking for. You can synchronize your Offside-DB with or "Online" ones
and you will have all Entries!

Look for some help here:
http://support.microsoft.com/kb/282977/en-us

Kai Apel (Berlin)

PD: hope I have understand it correctly

 

[Michael J. Strickland]

In the destination database:

File->Get External Data->Import

Then select the database you want to import from.

Then select the objects (e.g. tables, queries, forms,reports) you want to
import.

There shouldn't be any interference with the destination database. Even if
the
objects have the same name as existing ones, Access will rename them (e.g.
Table1).