Information générale
Catégorie:
Codage, syntaxe et commandes
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement