My guess is that one of values is bigger than the size of column. I'm afraid you'll have to compare each of numeric values to the max size of each column takind in accound the decimal part.

>

>1526 Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]
Arithmetic overflow error converting numeric to data type numeric.
>

>
>this is the sql line that I had sent at the time. modified to fit in this box < g >
>
>

>Insert into dirdesc values ('6031.039001   6031.001   1    ', '6031.001   ', '6031.039001   ', 1.00, 1.00,
>   '                                                                      ',
 ' ', -102365.00, '10 AVE NW & 33 ST NW                                        ',
>   27.00, 'MT-UF---------00', '6031.039001   6031.001   1    27   ', 
24209.00, 24210.00, 0.00, 0.00,
>  '6031.039001   6031.001   1    27   2    ', '6031.001   27   ', '                                   ')
>

>I added hard returns after the data seperator(,) to hopefully make it more readable
>
>Thanks.
>>Can you post the whole error message?
>>