See this article for an example of using Excel PivotTables to make some very interesting and very powerful/flexible reports with Excel. In my case I once pushed up to 500,000 rows of Oracle data via VFP into an Excel PivotTable.

http://www.levelextreme.com/Magazine/June2002/Page13.asp

Even if you do not use PivotTables, this article will give you some insights on how to automate and control Excel from VFP...

>Generate your report into a cursor, then copy straight to excel, as in

>select bla bla bla from .... into cursor MyReport
>copy to MyExcel.xls type xl5
>

>If you need more sophisticated excel files created, you can use excel automation.
>
>HTH
>Jaime
>
>>Hi, I would like need to generate my Vfp reports to an excel file, can somebody help me?
>>
>>Thanks,
>>
>>Andrickson.