in reply to Possible faster way to do this?
I need to know what type of data each column has.
Ask the author of the file. Seriously, why double-guess formats when you can have the definitive answer and probably in less time, too?