10 digit figure

[Roberto]

Hello,

I am trying to import a 10 digit figure from a text file into access. The
field is configured as long integer but it will not import that specific
figure. It crops the last digit.

Should it be a text field instead of a long integer? Any recommendations?

 

[Ken Snell \(MVP\)]

The largest number that you can store in a Long Integer datatype field is
2,147,483,647 (or -2,147,483,648 for negative numbers). Most likely, your
10-digit number is larger than this.

If you don't mind storing the number as a floating point number, use a
Double datatype field. Otherwise, yes, store it as a Text datatype field.

 

[Roberto]

Ken,

Thanks for your prompt response. Pardon my ignorance, but why would I mind
storing a number as a floating point number? In other words, what does
floating point mean?

Roberto

 

[Ken Snell \(MVP\)]

Floating point numbers are numbers that can have decimal values (e.g.,
34.56, 1.2567, etc.). Because computers cannot 100% accurately store numbers
to the "nth" decimal place, the number 4 might be stored in the computer as
3.99999999999998. Depending upon how you use the value, this may or may not
cause a problem for you -- for example, if you want to compare this number
to the number 4, you may not get a match; but if you do a calculation, it
may not cause a problem with the result.