General information
Category:
Coding, syntax & commands
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only