in reply to Possible faster way to do this?
A tool I used just looked at the first 20 rows, and guessed from that. It was interactive, so you could change the type for each column at time of ingestion. You could also change the number of rows to preread.
-QM
--
Quantum Mechanics: The dreams stuff is made of
In Section
Seekers of Perl Wisdom