I'm using Visual FoxPro 6.0 and EXCEL 2003. I created a query wit
FoxPro 6.0 and copied it to EXCEL 2003. The Table size is 3382
records and it only copied 16384 records. Why is this

Here is the code

close data al
set talk o
set dele o

SELECT
USE "c:\documents and settings\bartech\my documents\fmpdata\softwar
code\fmp reports\fmptables\line02.dbf" share

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

select

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

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

Hi,

As Tamar said in the Microsoft Technical Forum, use .....TYPE XL5 rather
than ....XLS. XLS is Excel 2.0, which had a smaller limit than XL5.

--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


"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.

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