Copy a table into a new blank db

X

XP

Using Office 2003 and Windows XP;

I just need to know the fastest, most direct, and expedient method of just
copying one table from one DB into a new blank DB, both are Access 2003.

The table to be copied is stand alone; i.e. no joins or connections to any
other tables.

I can do this using VBA or by manual steps, whichever is faster and most
expedient.

Thanks much in advance for your assistance.
 
O

Ofer Cohen

One way

1. Open the blank mdb
2. From the menu select File > Get external data > Import
3. Select the Mdb with the table, you'll get a list of tables , select the
table and OK
the table should be copied to the new mdb

Second way
1. Open the Old mdb
2. From the menu select: File > Export
3. Select the new MDB and press Ok
 
Top