Copy an existing table structure into a new Access database - TechRepublic
Data Management
TEILEN
Facebook X Pinterest WhatsApp

Copy an existing table structure into a new Access database

If you’ve been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table structure to a new table in another database.

Verfasst von
maryannrichardson
maryannrichardson
Jul 26, 2005
We may earn from vendors via affiliate links or sponsorships. This might affect product placement on our site, but not the content of our reviews. See our Terms of Use for details.

Have you been eyeing a Microsoft Access database that has a
table whose structure you would like to use to create a table in another
database? If so, you should consider copying the table structure because it
could save you a massive amount of time when you go to create a new database.

To copy the table structure, follow these steps:

  1. Right-click
    the existing table name in the Database Window of the original database
    and click Copy.
  2. Close
    the database Window and open your new database.
  3. Under
    Objects, click Tables. Then, right-click the database Window and click
    Paste.
  4. Enter
    a name for the new table, choose Structure Only,
    and then click OK.

When you open the new table in Design view, it will have the
exact same table structure as the original. Now you can now make any changes to
the table structure to customize it to fit your needs.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

maryannrichardson