Office Tips and Hints Blog

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Monday, February 20, 2006 – Permalink –

ACCESS

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
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 97, choose File>Save As/Export, select the To An External File Or Database option)
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 Topics

<Doug Klippert@ 7:06 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>

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

Create a Link