I'm using this to import a CSV file into a table in Access 2003:
DoCmd.TransferText acImportDelim, "LOC2010", "T-LOC Current Import", strRPTLoc, True, ""
It works for everything except when there is a negative number in the Amount field. Another table gets created with the import errors and it says Type Conversion on the Amount field.
The data type for the Amount field is Number and the Field Size is Double (see Table Structure snapshot). Also attached is the Import Spec I'm using (LOC2010).
How can I fix this?
Thanks for any assistance!