Copying/Pasting Tables

B

Bob Watson

Access 97 -

I have two MDB files which I need to
copy a number of tables from one to the
other ... maybe about 40 tables. The
only way I have figured out how to do
this is one-by-one and then you have to actually
name it on the "receiving end" (paste).
Is there a way to copy a large group
of tables and paste them while maintaining
the same name?? MultipleSelect-Copy-Paste ???

TIA,
Bob
 
G

Gina Whipp

Did you try opening the new database and selecting File... Get External
Data... Import. A window opens and you can Select All and bring into your
new database, keeping names and all.

Hope that helps
 
V

Van T. Dinh

You can use File / Get External Data ... in the destination database to do
multiple-Table import.
 
Top