Copy a table in an external database

's Computer Specifications

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

's Computer Specifications

On Fri, 17 Jul 2009 18:17:01 -0700, Andrew@Rays
<(E-Mail Removed)> wrote:

>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.
--

John W. Vinson [MVP]

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Disconnect from external database when creating a copy	Sam	Microsoft Excel Worksheet Functions	0	28th Jul 2010 06:56 PM
Copy table from open database to a closed database	RW	Microsoft Access VBA Modules	6	2nd Dec 2007 12:40 AM
Copy external to local database -- Access 2000	L.A. Lawyer	Microsoft Access VBA Modules	4	23rd Jun 2005 12:22 PM
copy data to external table	Jean-Paul De WInter	Microsoft Access Form Coding	0	20th May 2005 01:40 PM
Failure to import a table to other database & make a copy in the same database	Ray	Microsoft Access	0	2nd Oct 2004 09:33 AM