Export Data and update data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Replacing a Table with a Table from another database - reference issues 1
Same record/Primary key in multiple tables 0
Exporting query to table in external database 4
Using multiple databases 3
Clean all "data" from a database 3
VB and set of Data bases 2
Error Message after exporting MS Access Table 0

Back
Top