Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Exporting large files to Excel
Message
De
10/11/2004 15:26:03
Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, États-Unis
 
 
À
10/11/2004 15:14:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 7
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
00960188
Message ID:
00960198
Vues:
11
>I´m trying to export a file to excell, but only 16383 records are in the output file.
>there are about 40000 records in total that should be exported

David,

From the VFP8 help file, "Note Though you can export a maximum of 65,535 rows, which includes one row reserved for the field header, versions of Excel earlier than 8.0 (Excel 97) display only the first 16,384 rows and cannot import files containing more than 32,767 rows."

Also, VFP7 doesn't support copying to an Excel 8 or newer file.

A possible work around is to export the file as type Foxplus which Excel can import directly.

HTHs,
Jim
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform