Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem importing from Excel file
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Problem importing from Excel file
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01180794
Message ID:
01180794
Views:
58
I have a situation where I'm importing data from a simple two column spreadsheet. There are 894 rows. All 894 rows import just fine, but at the end of the file I get some junk.

This is what I get. As you can see, the last record (and all the ones before that) is imported fine, but I get three additional records. Lines 895, 896, and 897 in the spreadsheet are completely empty - no data, no formula.
Record#  ITEM               PRICE
    894  7580KTPA           55.05
    895  0                  
    896  7.7468171E-304     
    897                     3.33E-308
Unfortunately, I get a numeric overflow error. But where the heck does it find this nonexistent data?

Russell Campbell
eCost.com continues to rip people off
Check their rating at ResellerRatings.com
Next
Reply
Map
View

Click here to load this message in the networking platform