Copy a table into a new blank db

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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