setting or changing multiple field sizes in one pass

[markbrum]

Hi,

I have my default field size for a text field set to 50 chars in Access.

When I import a CSV it comes in with all text fields set at 255 chars.

Can I either change something on import so that the CSV fields all come in as 50 chars or even better, can I run a query or macro to change all fields to 50 chars after export?

Thanks for any help.

Mark.

 

[lameid]

Easiest way is to import to an existing table with the correct field size.

Alternately you would need to use code to add a field to the table with the correct size, update the data to this field and delete the original field.