I suppose we always have automation.
Not quite as simple and I'm certain its not as fast, but I'm really starting to like it as an alternative to reports anyway.
Bill
>This is not a bug. This is by design because XL5 had a 16K record limit. For perf resons we only exported the number of records XL5 could consume.
>
>XL7+ has a 64K record limit.
>
>The sad note is VFP doesn't support exporting to any version of Excel beyond XL5.
>
>Dave
>
>>Hi.
>>
>>I would like to copy data from a VFP table to a file of Excel 5.0.
>>So I used COPY TO command.
>>
>>Select customer
>>COPY TO c:\cutomer.xls TYPE XL5
>>
>>The customer table has 60,000 records. COPY TO command ran without any errors. But when I opend customer.xls at Excel 7.0, there were 16,384 rows.
>>
>>Is that a bug?
>>help me.
>>
>>Thanks.
Bill Mittenzwey