here it is:

create table DIRDESC (runstopcom char(30) NOT NULL , run_id char(11) NOT NULL , fstop_id char(14) NOT NULL , ;
stop_post numeric(5) NOT NULL , dir_post numeric(5) NOT NULL , direct_desc char(70) NOT NULL , ;
act_cod char(1) NOT NULL , mileag numeric(8,4) NOT NULL , streets char(60) NOT NULL , ;
cover12 numeric(5) NOT NULL , frequenc char(16) NOT NULL , covercom char(35) NOT NULL , ;
node11 numeric(10) NOT NULL , node12 numeric(10) NOT NULL , ddhead numeric(1) NOT NULL , ;
checkpnt numeric(1) NOT NULL , rscoverps char(40) NOT NULL , run_cover char(16) NOT NULL , ;
rrwarn char(35) NOT NULL  )

>I don't think so. Can you post the table DDL?
>
>>What about 1.00 trying to fit into a (1,0) field would that cause this problem? or 0.00?
>>
>>
>>>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.
>>>>

>>>>