Unable to execute statement 'COPY 2626675 OFFSET 2 RECORDS INTO OPPR_ALL_DTL_GNRL_09302014 FROM 'C:\Users\anthonyd\AppData\Local\...'.

Server says '!value '1  ' from line 1 field 51 not inserted, expecting type double'.

i could import it as VARCHAR and then CAST it back into a DOUBLE type, but i'm wondering if anyone has an easier/more clever way to import this?  handling it manually would mean that i cannot use the monet.read.csv()  function, so it's a bit more work.  thanks!