Copy a table in an external database

[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

 

[John W. Vinson]

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

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.