moving a table from one copy of the data base back to data base

[Robin F.]

Folks,
I copied the data base, made some changes, and didn't get it back to the
server in time. Now we have this copy of a table, and the "main" data base.
How do I get the table I worked on, back into the "main" data base? The other
tables in the "main" data base are find, and I need to be very careful not to
mess them up! Help!

 

[John Vinson]

Folks,
I copied the data base, made some changes, and didn't get it back to the
server in time. Now we have this copy of a table, and the "main" data base.
How do I get the table I worked on, back into the "main" data base? The other
tables in the "main" data base are find, and I need to be very careful not to
mess them up! Help!

You can - *AFTER MAKING A BACKUP AND TESTING IT!!* - use File... Get
External Data... Import to import a table.

This must be done with due care! If the table is related to other
tables, and if someone has been adding data to the table while you've
been working on a different copy of the table, you will have to
migrate the data from the old table into the new one. Depending on how
the table's relationships are set up this might pose some hassles.


John W. Vinson[MVP]