How to import Table Definition from one Access db to another

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

I want to create a table in a new data base exactly like a table in another
data base.

I don't want to have to manually define each field again.

How can I just import the Table Definition without the data that is in the
table into my new data base?

Thanks for the help.

Will
 
Will said:
I want to create a table in a new data base exactly like a table in
another data base.

I don't want to have to manually define each field again.

How can I just import the Table Definition without the data that is
in the table into my new data base?

You can use the regular database import process invoked by File -> Get
External Data -> Import.... Choose to import from the database that
contains the table you want to copy, select that table in the Import
Objects dialog, and click the "Options >>" button on the dialog to
reveal the additional import options that are available. There in the
"Import Tables" option group you can choose to import "Definition Only".
When you've done that, click the OK button to import just the definition
of the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top