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?