>>Hello All, it's been a while!
>>
>>I have an XLS file (5/95 version). I am trying to import this into a DBF using the APPEND FROM ... TYPE XL5 command. It works but I get an error with Numeric Overflow - Data was lost. The XLS file can contain #NUM values in some numeric cells - the data is not important and I dont mind losing that. All the other data is imported OK. Question: is it possible to import the file without the program being halted to display this overflow error message?
>>
>>[UPDATE] solved this with a custom XLS reading routine.
>
>
>Good to see that you are back! It looks like you have already solved your problem but I think you might also use an "ON ERROR" to and error handler procedure that did something like this ( I haven't faced this problem in the last 15-20 years):
>Only if you really don't care about the lost data
>PROCEDURE overflowerror
>PARAMETER merror
>?merror
>DO CASE
>CASE merror = 39
>ENDCASE


Thanks Sammie. Nice to see you still here.