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

R

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

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]
 

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

Top