Import with 0.01 getting error on import

[BHScripter]

I am importing a large pipe delimited file into access and the column with dollar amounts have some entries like 0.01 I have tried setting the field type to double and currency and each time the fields which are 0.01 cause an import error.

the data is coming from a sql db export and the line of code for the export which is creating the column is:
, CONVERT( varchar, abs(d.sAmount) )

Thanks for any help

 

[lameid]

What happens if you just export the one record or copy and paste the one record into a different file and import it?

I am assuming of course the text looks like what you expect. If not, you should probably post in the SQL server forum. BOL says abs returns the same datatype past to it so long as it is numeric, I don't see why you should have a problem unless text is qualified somehow.