Importing file with trailing minus signs

N

Nosmo King

Hi Pat,

Not sure if this helps any, but could you do a
Find/Replace to change all the minus signs in the text
file to null strings (ie. replace "-" with "")? That is
assuming you actually want to get rid of the minus signs
of course. Are you saying that if the text in the file
says "200.00-" that you want to convert that to the
number -200 inside the field in Access?
 

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

Top