updating tables

[Guest]

How do you update fields in a table in one database using data fields from
another table in another database?

I have two databases that are the same except one table has data in some of
the fields so I need to get that data into the other database.

 

[Rick B]

Why do you have redundant databases?

The normal way to do this would be to link to the complete database and use
the data from the complete table there without the need to create two exact
copies and try to keep them in synch.

If you simply want a copy, why not delete the partial table and then paste
in the complete table?

Please explain more about why you need to do this.