I did a fast test using schema.ini file descriptors, the trick is to instruct ms jet engine to parse your scientific field as Float.
You could read more on the subject here
Col3=FieldB Float Width 8
Cristian, I don't use text files much, but this is good to know. Thanks.
The real file I have actually has hundreds of columns. It is very impractical to specify a format for each column. Schema.ini cannot specify format for only one column as far as I can tell. Is this the only solution?
I shall warn you that ms jet engine is not a robust one, and if you fave malformed records/cell on original input file then will became NULLs on Tableau Data Engine. I did a second test with only 2 fields defined in schema.ini and 6 fields on .csv and it works without any issue.
Please check the attached files.
If i remember right the maximum number of columns is 255, please search the forums and see how others override this issue.