Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Truncation in XLS 3
Message
De
02/10/2006 13:10:43
Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, États-Unis
 
 
À
02/10/2006 13:03:17
Information générale
Forum:
Windows
Catégorie:
Informatique en général
Divers
Thread ID:
01158607
Message ID:
01158609
Vues:
30
>Hi
>
>I import an HTML file into Excel. Fine - no truncation.
>
>However, the XLS needs to be processed by an old FPD2.6 system, so I save as an XLS 3, so the old system recognises it.
>The data are then processed into a DBF.
>
>It's just been noticed that a fair slice of the data have been lopped off, to 16384 rows.
>
>I suspect thet Excel 3 has a max file size limitation, of c. 16K rows or something like that. Is this the case? I haven't a copy thereof to check.
>
>Secondly, any ideas on how to get round this? (I saved to Excel 3 as a precaution, as FPD2.6 won't recognise 97 as I have on board) How recent can I go with Excel versions?
>
>'ppreciate it.
>
>Terry

Yes, it is limited. But you can append from the regular XL file in VFP and then use COPY TO to save it as a FPD 2X file.

Regards,
Jim
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform