Numeric Field Overflow

[Guest]

I keep receiving the error "Numeric Field Overflow" I understand that this
means that one of the columns contain data that exceeds the maximum of the
field. Does anyone know how to determine which filed is causing the problem
I have over 100 fields of data of which all are either TEXT or DOUBLE INT.

 

[Guest]

Are one of the tables a Linked Excel Table?
If so, it is a known issue - look at the KB:
http://support.microsoft.com/?kbid=223225

jmonty

 

[John Vinson]

I keep receiving the error "Numeric Field Overflow" I understand that this
means that one of the columns contain data that exceeds the maximum of the
field. Does anyone know how to determine which filed is causing the problem
I have over 100 fields of data of which all are either TEXT or DOUBLE INT.

Well, it's got to be an INT field - might you be trying to store a
ten-digit number in a LONG INT? They're limited to 2 billion odd.

If you have 100 fields in your table - you almost surely need to
normalize your table structure. Or are you importing from a wide-flat
datasource into normalized tables? If so, maybe you can link to the
datasource and use Append queries to migrate the data - this will give
you a chance to go field by field and identify the culprit.

John W. Vinson[MVP]