Import from Text File - "Type Conversion Failure"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am importing a large amount of data from a text file. When i try to import
it, for some of the fields, i get a "Type Conversion Failure". From what i
can tell, it has to do something with the size of the number i am importing.
An example of a number which does not import is 24004518746.

How can this be fixed? Is there a default setting i should change with
regards to field size?
 
An Access Long Integer will hold numbers from –2,147,483,648 to
2,147,483,647. Your number is about 10 times that.

Is it really a number OR numerical characters? To tell answer this question:
Are you going to add, subtract, divide, multiply or do any other math with
24004518746? If not, it's really not a number similar to a phone number or
social security number. Store it in a text field where it will fit nicely.

If it's actually a number, they you might need a database like Oracle to
handle something so large.
 
It is an actual number of total assets for a company. I fixed the problem by
simply making it a number and changing the field size to "double"
 
Back
Top