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:
01180804
Vues:
15
Yes, I had thought of that, but not gotten to it yet (I was doubtful about that solution, since this is Excel 2002). I just tried it. Unfortunately, my doubts were correct. Same problem. But then I just saved it in the Excel 5.0/95 format and the problem is solved.

This is one of the irritating issues with VFP - that they haven't updated the capabilities of import/export as the newer versions of Excel have come out. I don't always see this problem, but I did in this spreadsheet for some reason.

Thank you for your help.

>Also, try TYPE XLS, it may not be an Excel 97 original format.
>
>>No, they are visible. I did a Clear on them (hightlight the cells, Edit/Clear/All) and tried the import again and got the same thing.
>>
>>The code is:
>>
>>
>>CREATE CURSOR ImportCursor;
>>	(item c(15), price n(10,2))
>>APPEND FROM <ExcelFileName> type xl8
>>
>>
>>>Hi,
>>>Are the rows hidden in the spreadsheet.?
>>>
eCost.com continues to rip people off
Check their rating at ResellerRatings.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform