Since this is an Excel programming group not sure what the Foxpro code does.
It is highly likely that the version of Foxpro you are using can only create
Excel files within the limit 16,384 records. Excel V2 standard I think?

Upgrade your Foxpro might be the solution ?

--
Cheers
Nigel



"tgorrie" wrote in message
...
I'm using Visual FoxPro 6.0 and EXCEL 2003. I created a query with
FoxPro 6.0 and copied it to EXCEL 2003. The Table size is 33827
records and it only copied 16384 records. Why is this?

Here is the code.

close data all
set talk on
set dele on


SELECT 0
USE "c:\documents and settings\bartech\my documents\fmpdata\software
code\fmp reports\fmptables\line02.dbf" shared


select *;
from line02;
group by 3,4,5,6;
order by 3,4,5;
into cursor x

select x

copy to c:\line02wmake&model.xls type xls