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

  • Thread starter Thread starter BR001
  • Start date Start date
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+
 
You'll probably need to import it into a text field. Then later figure out a
way to convert it to a number.
 
Back
Top