View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tgorrie tgorrie is offline
external usenet poster
 
Posts: 1
Default converting a file to EXCEL from FoxPro.

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