How to change many field sizes in the design view/ field property settings in bulk

[TuffStuff]

I'm working on a mini project which involves importing data from excel (over 100 fields). Most fields are number types. I want them stored as doubles, but the preset is text and then long int. This creates a thankless chore of, after making each field, setting the data type to number and then going into the property panel and changing the type to a double. Saying this is tedious is an understatement. I'm currently working through this now, but will likely have to do something similar in the future. I'd like to be able to set a default field type and field size, or at the very least be able to develop a macro/vba which can change them to cut down on the amount of mindless clicking that must be done.

Any help would be appreciated

[ranman256]

There's no need to alter fields.
you make a table with the correct field types.
empty this table,
Import the excel data to it, then
Validate the data here then add it to the main data. (Or import straight to the main data table)

you don't import, then alter fields.

[CJ_London]

you can go to File>Options>Object designers - table design view and change the default field type and size there