How do I import a signed field into access data base?

B

BR001

I am attempting to import a .txt file into an ACCESS table and a premium
field that has a + or - sign as the final character is rejected by ACCESS.
Example of the field: 00000090000+
 
J

Jerry Whittle

You'll probably need to import it into a text field. Then later figure out a
way to convert it to a number.
 
Top