Import problem into SQL Server 2005 linked table

[hedgracer]

I have an import problem into an sql server 2005 linked table. The
field is an int with null checked. It is a number of contracts field.
The linked table in Access 2003 I have set as a long integer (the
default) with 0 decimal places. I have an import specification set up
as fixed width and have no trouble with that on any of the other lines
in this file I am importing (a text file). This is the line I am
having trouble with:

PE20090616800 800 560 7AE60055 7AE60055
TDRAKE 560Y 05USD00000005059125 00000000000000 00000000000000
00000005059125 00040473 NN X

For whatever reason the 00040473 is throwing a "numeric field overflow
error" every time I import it. I am not getting this error on any
other line (there are hundreds of lines in this file) so this is
extremely puzzling. One other tidbit of information: when that number
changed to 00032666 it imports into the table. Change the number to
00032777 and it throws the error. Can anyone give me a clue on this
one? Any help is appreciated.
Thanks.
Dave

 

[Tom van Stiphout]

On Mon, 22 Jun 2009 06:33:19 -0700 (PDT), hedgracer

Sure: remember the old 2^15-1? That's the maximum value for a 16-bit
integer.
So something is interpreting your data as integer, rather than long.

-Tom.
Microsoft Access MVP