Implications of Schema errors?

[mobmsc2]

Is it possible for schema issues in an Excel input file to cause problems in other columns? For example if I have a excel with 100 columns and column 34 is undersized or others could it impact on comparisons values involving columns 12

(earlier)

or 64 (later).

My query isn't about truncated data, its about unexpected consequences. Are excel file structures more robust compared to delimited files for example?

Thanks

Michael

[Anonymous]

Hi Michael

I think i don't understand your question well, what do you meant 'Schema error'? it might be wrong column name or data type?

Regards

Shong