converting a file to EXCEL from FoxPro.

[tgorrie]

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

 

[Nigel]

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 ?

 

[Cindy Winegarden]

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
(e-mail address removed) www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden