Search code examples
excelvisual-foxprofoxpro

Cannot export all rows from foxpro to excel?

I'm trying to export tables from foxpro to excel, But it didn't export all rows from foxpro.
I have 82377 rows in forxpro table, after I exported to excel, I found only 65534 rows in excel. I tried another foxpro table which had 67548 rows, but after exported, I found the same as the old one 65534 rows in excel and other tables and got the same result.

I'm using Microsoft Visual Foxpro 9.0

Solution

  • That is correct... VFP never expanded the export to excel format past the 64k limit of earlier Excel files.

    Copy out via CSV and it will dump them all... Excel will still be able to read CSV file format.