Importing Data from FoxPro to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
We're using 6.0

Gord Dibben said:
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
Click to expand...
 
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
 
Thanks so much!!!

Gord Dibben said:
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
Click to expand...
 
Back
Top