>Cetin,
>
>>It's not fault of VFP but Excel. Excel5 had only 16384 rows. Try a copy with type xl8 or xls.
>
>Type xl8 is not valid on export, only on import.
>
>Kjell,
>
>xls and xl5 both have this limitation. The only way to export it is to break it into 16K chunks of records, and combine in excel after you have exported it, or to do OLE Automation to poke the records through.
>
>Cheers
>Steve Lea
You're right onlimitations :) Then this works as an easy alternative to combining chunks :
create cursor mytest (orderno i, ttime t, productname c(10))
for ix = 1 to 50000
insert into mytest values (ix, datetime() - ix*5, "Prod"+padl(ix,5,"0"))
endfor
copy to myxls.xls type delimited with tab
oExcel = createobject("Excel.Application")
with oExcel
.WorkBooks.Open(sys(5)+curdir()+"myxls.xls",)
.visible = .t.
endwith
Cetin