>I have created a dbf using the create table command. I have a field I created
>as N(2). I have an var which holds the value 1 , when I do a replace RceaNumber
>with aAr(3) I get a type mismatch error. I have SET NULL ON because some fields
>that I read in from this text file are empty ie: ,,,,,, just commas no values
>for some fields. Can anybody help. Thanks for any help.
'From the text file..'. I suspect aAr(3) is character "1".
Replace RceaNumber with val(aAr(3))
then. From text file append from is much faster - if file,reccount is huge replace approach might be very slow.
Cetin