dcozzi said:
I have about 50 or so records which i am importing from a text file.
Most of them import correctly but there are a few that i get a "Type
Conversion Failure" and no data is imported for that field. How do i
prevent this so that all my data gets imported?
This is the number which i am trying to import 24004518746
Perhaps the number is too large for the number size type:
Byte
Stores numbers from 0 to 255 (no fractions).None1 byte
Decimal
Stores numbers from -10^38-1 through 10^38-1 (.adp)
Stores numbers from -10^28-1 through 10^28-1 (.mdb)2812bytes
Integer
Stores numbers from -32,768 to 32,767 (no fractions).None2 bytes
Long Integer(Default)
Stores numbers from -2,147,483,648 to 2,147,483,647 (no fractions).None4
bytes
Single
Stores numbers from
-3.402823E38 to -1.401298E-45
for negative values and from
1.401298E-45 to 3.402823E38 for positive values.74 bytes
Double
Stores numbers from
-1.79769313486231E308 to
-4.94065645841247E-324
for negative values and from
4.94065645841247E-324 to
1.79769313486231E308 for positive values.
It might also be that some of your "numbers" may have non-number
characters, like
24004518746
24004518748
