"Numeric field overflow"

[Robin Chapple]

I have a routine that has been running for seven months. One operation
is to append records to a table.

Today I get the error message:

"" Numeric field overflow ""

The information from Google search did not help.

Where do I look for an answer to this problem?

Thanks

 

[Dan Artuso]

Hi,
It sounds like you're tyring to enter too large a value in one of your fields.
For example, you may have a field defined as an Integer data type and are trying
to enter a value greater than 32,000.

Take a look at the data types of your fields and see what kind of values you're
trying to insert.

 

[Robin Chapple]

Thanks Dan,

I went back to the CSV file from which the data is sourced and it was
corrupt.

All is now well.

Cheers

Robin

 

[fofa]

Numeric field overflow should mean you have exceeded the limit of the
data type for a numeric some where. It is like putting 20 characters in
a field defined as 15 long. Typically this is not an issue with a
autonumber, because it can be so big, so you need to decide what is
happening to a number field. Do you have any yes/no fields you are
trying to put a number in? Maybe an INT field you are summarizing and
it is over flowing.