Create Table from Data Dictionary

[JayB]

I received a data dictionary today in the form of an Access table (contains
field name, type, and size). Can I create the table in Access using this
data dictionary with some sort of import feature or will I have to create
these fields myself?

Thanks,

 

[Douglas J. Steele]

Are you asking whether you can get the data into Access, or whether you can
use it to create the tables in Access for you?

The answer to the first question is yes. Looking under File | Get External
Data | Import

The answer to the second question is that Access has nothing built into it
to do this for you. However, it shouldn't take that much work to write VBA
code to take the data and generate your database from it.

 

[JayB]

Are you asking whether you can get the data into Access, or whether you can
use it to create the tables in Access for you?

Create the tables.

The answer to the first question is yes. Looking under File | Get External
Data | Import

The answer to the second question is that Access has nothing built into it
to do this for you. However, it shouldn't take that much work to write VBA
code to take the data and generate your database from it.

scripting it is!

Thanks!