Copy a table in an external database

  • Thread starter Thread starter Andrew@Rays
  • Start date Start date
A

Andrew@Rays

Hi,

Can you please tell me how to copy a table in an external database.

Current Database C:\DB1.mdb
Target DB C:\DB2.mdb

The table to be copied is Tbl_Table1 in C:\DB2.mdb and is is to be called
Tbl_Copy_Of_Table1
 
Hi,

Can you please tell me how to copy a table in an external database.

Current Database C:\DB1.mdb
Target DB C:\DB2.mdb

The table to be copied is Tbl_Table1 in C:\DB2.mdb and is is to be called
Tbl_Copy_Of_Table1
Click to expand...

Use File... Get External Data... Import (or Export, depending on which
database you're in when you do it) on the Menu.

If this is a recurring operation, look at the VBA help for the
TransferDatabase method.
 
Back
Top