I am working on a project where I have specifications for a database
table that are in Excel. I need to create this table in MS Access but
there are over 500 fields and i am trying to avoid having to manually
enter all of these fields and specifications (i.e. numeric, 0 decimal
or text, 25 max length).

Is there anyway to import these specifications (not the table data
itself) into Access so it creates the table design? I then have test
data (csv file) that I would like to import into the table with the
given specifications.

Is this possible and if so how? Any help is appreciated.

saner.junk (AT) gmail (DOT) com wrote:
Yes...and no.

From Help (see Specifications)
Table specifications

Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255

I'm glad the limit is 255. Can you imagine 500 fields to keep track of?

http://www.mvps.org/access/tables/tbl0016.htm

In online help you should look at CREATE TABLE Statement or
CreateTableDef Method as starters. Alter Table, CreateField Method ,
CreateIndex Method, and Append Method are also topics to review.

You might want to go to http://groups.google.com/advanced_search?q=& and
hunt for these topics as well. Enter your kewords and in the group name
textbox enter comp.databases.ms-access.

Salad wrote:

Oh yeah, you can also try File/GetExternalData/Import (or Link) as well