CODEWITHSUNDEEP
excelvisual-foxprofoxpro
Alwayz Change
Alwayz Change

Reputation: 225

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

Upvotes: 2

Views: 3283

Answers (2)

Feuerwehrler
Feuerwehrler

Reputation: 51

I think you are using COPY TO for doing this export. Sine COPY TO always creates files in the Excel 5.0 Format there will be no way to export more than 65534 rows. But if Excel and the VFP OleDB-Driver are installed on the system the export runs you can use the API for doing this. Just create in your program a free table with only the data you want to export. Then open Excel by using the API and fetch the data from the table you just created before via OleDB! On this way you are able to get as many rows as the installed version of Excel supports. So if Excel 2007 or 2010 is installed you are able to export your 82377 rows!

Upvotes: 0

DRapp
DRapp

Reputation: 48139

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.

Upvotes: 3

Related Questions