Importing data from SAP

  • Thread starter Thread starter Willie (Ireland)
  • Start date Start date
W

Willie (Ireland)

I've imported data into Access from SAP via a txt file. However, SAP places
the minus sign to the right of negative values (money) and Access wants the
minus sign to the left. There are about 300,000 data records. Any idea of how
I can easily change the location of the minus sign in all records to the left
of negative values?
 
Willie,
Here is a query that switched the minus sign.
UPDATE tblTxtImport SET tblTxtImport.Amount = "-" &
Left$([MyNumberText],Len([MyNumberText])-1)
WHERE (Right$(Nz([MyNumberText],0),1))="-";

tblTxtImport is the table holding the import from the text file.
The field Amount is formatted as currency and is an empty field in the table
ready to receive the corrected currency values
The field MyNumberText is the field that holds the imported currency values
as text

Jeanette Cunningham
 
Back
Top