Importing Data from FoxPro to Excel

[Guest]

I have a fairly large FoxPro database and I want to import it into Excel.
The import always stops around 16,000 rows. Does anyone have any idea why
this would be happening?

 

[Gord Dibben]

What version of FoxPro?

Just a guess, but maybe an older version thinks Excel still has 16,384 rows
maximum?

Can you export first to a text file then open in Excel?


Gord Dibben Excel MVP

 

[Guest]

We're using 6.0

What version of FoxPro?

Just a guess, but maybe an older version thinks Excel still has 16,384 rows
maximum?

Can you export first to a text file then open in Excel?


Gord Dibben Excel MVP

 

[Gord Dibben]

This site indicates that FP 8.0 upgraded the number of rows to 65536 from
16384.

http://msdn.microsoft.com/library/d...l/fogrfBehaviorChangesSinceVisualFoxPro70.asp

Scroll down about 2/3 of page to find this............

Visual FoxPro raises the maximum from 16,384 to 65,535 rows when exporting a
data cursor to an Excel spreadsheet. The new limit includes one row reserved
for the field header. For more information, see EXPORT Command, COPY TO
Command, and The Process of Exporting Data.


Gord

 

[Guest]

Thanks so much!!!

This site indicates that FP 8.0 upgraded the number of rows to 65536 from
16384.

http://msdn.microsoft.com/library/d...l/fogrfBehaviorChangesSinceVisualFoxPro70.asp

Scroll down about 2/3 of page to find this............

Visual FoxPro raises the maximum from 16,384 to 65,535 rows when exporting a
data cursor to an Excel spreadsheet. The new limit includes one row reserved
for the field header. For more information, see EXPORT Command, COPY TO
Command, and The Process of Exporting Data.


Gord