Copying/Pasting Tables

  • Thread starter Thread starter Bob Watson
  • Start date Start date
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
 
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
 
You can use File / Get External Data ... in the destination database to do
multiple-Table import.
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
Paste button disabled in Access 2007 form 1
searching multiple tables 2
Copy record in same table... 4
Access2003 Error 3001 1
Copying and Pasting Records from one table to the next 3
Document .mdb Table Fields, Type, Size 2
How do I copy a record from one table to another table in Access 1

Back
Top