Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

Saturday, April 18, 2009 – Permalink –

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:

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

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

Select the appropriate table in the Database window.
In Access 2000 and above, choose File>Export.
(If you're using Access 2007, choose More in the Export group)
Click OK.
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

[Edited entry from 2/20/2006]

Topics

Labels: Access

<Doug Klippert@ 3:35 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link