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:-)
![Clapping :clapping:](./images/smilies/clapping.gif)
![Sad :sad:](./images/smilies/sad.gif)
sorry for delay but i can test tomorrow...HansV wrote: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.