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.
 

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

Dynamic Naming of Form Button 3
How to Create an S-Curve from Custom Field? 0
Autonumber field in Excel that behaves the same as Access 0
Some mail merge fields not pulling into document 2
Import Signed Numeric data 0
Copy previous record into form field 0
Import Excel 2010 table into Access 2010 - not listed as range 0
CSV import error only with code 3

Top