Import Negative Number with "-" on end

  • Thread starter Thread starter Mrsbee1960
  • Start date Start date
M

Mrsbee1960

I am trying to import data from SAP to Access. The negative numbers have the
sign at the end of the number and get kicked out as an error.
 
I am trying to import data from SAP to Access.  The negative numbers have the
sign at the end of the number and get kicked out as an error.
Click to expand...

Export them to text and then manipulate them in Access...

use RIGHT$ to find all values with a trailing minus sign, convert to
number and multiply by -1.
 
Back
Top