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

On Mon, 18 Apr 2005 09:25:02 -0700, djn wrote:

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?

We're using 6.0

"Gord Dibben" wrote:

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

On Mon, 18 Apr 2005 09:25:02 -0700, djn wrote:

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?

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

http://msdn.microsoft.com/library/de...alFoxPro70.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

On Tue, 19 Apr 2005 05:17:02 -0700, djn wrote:

We're using 6.0

"Gord Dibben" wrote:

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

On Mon, 18 Apr 2005 09:25:02 -0700, djn wrote:

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?

Thanks so much!!!

"Gord Dibben" wrote:

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

http://msdn.microsoft.com/library/de...alFoxPro70.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

On Tue, 19 Apr 2005 05:17:02 -0700, djn wrote:

We're using 6.0

"Gord Dibben" wrote:

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

On Mon, 18 Apr 2005 09:25:02 -0700, djn wrote:

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?