Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem importing from Excel file
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Problem importing from Excel file
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01180794
Message ID:
01180794
Vues:
59
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform