Import Negative Number with "-" on end

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.
 
P

Piet Linden

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing *.txt file containing negative numbers 4
Problems with Negative Numbers when importing a txt file 2
Importing data from SAP 1
Importing a text file with a negative number 3
Import numbers with trailing signs both positive and negative 2
Importing negative number formats 1
Numbers with Accounting Format 1
Number format errors with negative numbers 4

Top