2 DB with the same data

T

tflett

is there a way I could extract data from one database and import to another
database if the data is the same in both databases so i don't have to input
all the same data over again?
 
M

Mike Mueller

tflett said:
is there a way I could extract data from one database and import to
another
database if the data is the same in both databases so i don't have to
input
all the same data over again?
Click to expand...

Yes, and very easy. You create the second db and you can import any object
from the first database into the second.

An option you can also do is to have the tables in the copy database be a
linked table- the actual contents would be in the table on the main db, but
you could view and manipulate the data from the copy. This is very handy if
you have a need for a legacy db format (such as Access 97) and you have
people using newer versions.
 
Top