okay, that is not the problem. I thought maybe the negative number (i.e. -123320.00) may be the problem. My error does not specify which numeric field, just that it had problems, so the record did not get inserted into the table.

Do you have any idea what else I could look out to fix this?

Thanks for your help

>Looks fine to me. The first number is the size of the column in bytes, the second - number of digits total (Precision) and the third is number of digits after decimal point (Scale).
>>
>> I was not ever sure where to search on this. I go into my table properties to check why a value string is not getting put in. The error says that it had problems converting a numeric to a numeric. The field that seems off to me says in the size column "5(8,4)"
>> is this even possible?
>>