Unofficial Access Stuff

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, January 25, 2016 – 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

See all Topics access
Labels: General, Reference, Shortcuts, Tables, Tips, Tutorials

<Doug Klippert@ 3:47 AM

Comments: Post a Comment