i want to put long name into Name field (contract table). I've changed the max lenght value to 1.000 but when i load data through excel the name is getting truncated to 40 characters or something like that.
If you had tried to import that excel earlier before updating the field size or tried with a trial data, then the staging table for that field would have got the size of 40 or whatever it was loaded. You need to update the staging table field size to 1000 to allow to import.
