afaik, this is a problem for imports or transferspreadsheet function. Have read same, it's 8? rows or so, but what I read was about Excel sheets, not delimited text files. You can play around & test on various configurations (all numeric, all text, first numeric but lots of it then text) etc. to see what happens. Or you could link to the file as a table and use a query on it to append/update to a table you manually build first. That table's fields should be of the correct data type. In so doing, this is supposed to eliminate the problem, but this is not something I did so much as read about.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.