is there is an easy way to create a table with defined field properties.

I have an excel file with over 300 column names and there field length.

I can import the name by transposing the list and then importing however the field length will have to manually edited which i don't fancy doing,

any ideas???


Field Name Length
BATCH NBR 5
BATCH DATE 8
BATCH CODE 3
SUB PRODUCT 3
FILE TYPE 1

It may not be the most elegant way, but I would convert the XLS to .txt and import the word.txt document into an existing or new table.
While importing , you can define the width and all props of the fields thru the advanced import specification.

Hope that helps.