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
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:
01180795
Vues:
16
Hi,
Are the rows hidden in the spreadsheet.?

>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
Regards N Mc Donald
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform