Export Data and update data

D

Dig

I have a database with several tables linked together and need to export the
data to another database. The other database has same tables and design I
just need to delete the data in the new database and update it with the data
from the original database.

What is the best procedure for this?

Thanks
 
W

Wayne-I-M

Hi

It quite simple to export tables, querys, forms or whatever from one DB to
another. You can also "overwrite" these things. The promlem you would have
is of keeping the relationships (if there are any). If you google this you
will get many answers (quite a few of which simply don't work ??) but some do
so have a go on a backup DB.

Not sure how to keep relationships in an export/import but the tables
@stuff@ is not hard. Search this forum on "wayne-i-m Database / Drive to
Drive / Rename" for one method of doing it.

good luck
 
Top