Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing from Excel - Numeric Overflow
Message
From
15/04/2024 05:14:29
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Importing from Excel - Numeric Overflow
Miscellaneous
Thread ID:
01687850
Message ID:
01687850
Views:
75
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.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Next
Reply
Map
View

Click here to load this message in the networking platform