G
Guest
I hope somebody can help. I am importing a text file into access as a table. I am using the "import text wizard". I click on the advance button and I've set up the import specifications by field. For this particular import I have approx 30 fields that are money amount fields and they are defined in the text file as PIC S9(16)V99. When I define them in the import specifications, I define as Long Interger with a field length of 19. By doing it this way, I am able to pull in the whole number without decimals. This is fine because then I create a query where I take that field and divide by 100 to get the decimals. The problem I am having is that on this one particular import I get 1 import error (type conversion failure) for one record. The field that failed to convert = 2191896752. Records above and below it all converted correctly. I can not figure out why only this one record failed to convert for this field. The only thing I can see is that this record has the longest amount of all the records. Does anybody have any idea's or thoughts?