max lenght from column in access table...

[sal21]

How to calculate from each column in access table (old_table) the max lenght of string value?
Is important to set the max lenght of fileds into the new_table because alla fileds in new_table are text formatted.
I'm sure HansV understand my prob:-)

Note:
HansV i'm very happy to see you on one of my post:-)
remember 4 year old?

[HansV]

You can create a query

SELECT Max(Len([Field1])) As LenOfField1, Max(Len([Field2])) As LenOfField2, ... FROM [table_old]

This will return the maximum length of each field in table_old.

[sal21]

You can create a query

SELECT Max(Len([Field1])) As LenOfField1, Max(Len([Field2])) As LenOfField2, ... FROM [table_old]

This will return the maximum length of each field in table_old.

sorry for delay but i can test tomorrow...
tks in other case