Duplicate Table Structures

No need to reinvent

When setting up a database, you may find that there is a table structure in another database that would be appropriate. You could Import the table, but then you have to clear out the useless records.

Here's an easier way to do it:

1. Choose File>Get External Data>Import from the menu bar
   (External Data tab in 2007, then select Access in the Import group)
   
2. Select the database that contains the tables you want to copy and click the Import button.
   
3. Select the appropriate tables on the Tables sheet
   
4. click the Options button, select the Definition Only option and click OK

.

To export a table definition from your current database to another:

1. Select the appropriate table in the Database window.
   
2. In Access 2000 and above, choose File>Export.
   (If you're using Access 2007, choose More in the Export group)
   
3. Click OK.
   
4. Now, regardless of version, select the target database and press Enter

When the Export dialog box appears, select the Definition Only option button and click OK. See all



See all Topics