I need to import a text file into Access. One of the fields contained in the text file is in Signed Numeric format, which I need to convert to a numeric value in Access.
For example, 6705N in the text file should convert to -670.55 in Access.
For example, 6705N in the text file should convert to -670.55 in Access.