The 16384 row limit is imposed by the version of Excel that you are exporting to. The XLS option, if I remember correctly, exports to version 4.0 Excel file which has this limit. It appears that XL5 option also has this limit. You can export data to FOXPLUS dbf table and open that in EXCEL 2000 as a dbase4 format file without this 16384 limit. From EXCEL 2000 you can then save this DBF file to Excel 2000 XLS file.
You can probably automate excel to export the data to the later version XLS file. But using VFP Copy to XLS and XL5 format imposes this limit. I don't know if VFP7 made any changes to copy to excel functionality.
HTH
Elmer
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement