and I wrote a nifty VBA program that uses ADO to import the file into the worksheet. The problem is that the wrong datatype is being detected in the 5th column.
107.61 is being imported as 107
95.57 is being importated as 95
etc.
AFAICT, ADO "peeks" at the first few rows when determining which datatype to choose, because if you delete one of the first few lines of the csv file (one of the lines with missing data) then everything is hunky dory. 107.61 imports as 107.61, 95.57 imports as 95.57, etc.
Through trial and error, I narrowed it down to one row -- you only need to delete one of the first rows of the csv file for the 5th column to be imported as a Double instead of an Integer.
I Googled, and the answer appears to be to write a schema file. For various reasons, I don't want to do this. I want to force the 5th column to be a Double programatically.
I've included a really convenient spreadsheet and datafile. Can some kind soul please tell me how I can force the 5th column to be imported as a Double?
I know there are other ways of reading a text file, and perhaps I should've pursued them since I'm on "company time". However, at this point, it's personal. This is something I want to know, not necessarily accomplish (until my boss starts yelling at me to finish up already).
Reply With Quote
