Export Data and update data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dig - 30 Mar 2007 14:12 GMT

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

Reply to this Message

Wayne-I-M - 30 Mar 2007 17:26 GMT

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

Signature

Wayne
Manchester, England.

> 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
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message