> Hi Experts,
> I am trying to send report in excel.
>
> i follow 2 types for send report in excel
> 1 ) Frx2any
> I am not Satisfied . Because that report data can't come in excel row format
>
> 2 ) OLEcontrol.
> I am write a program to direct accessing in Microsoft Excel , that was sucess .
> but utility work only for one Table.
> Means I send my foxpro table data in Excel.
>
> But i wan't Send Report in to the Excel . in Excel Column Format
> Can u help me any body.
>
> Regards
> Amol Pawar
As Cathy says, XFRX can output to Excel, however, I find the format very unsatisfactory. The reason is that if you have any columns that overlap, like headings often do, then you get multiple columns in the result.
I've found the best way to export to excel is to use EXPORT to get the data into the spreadsheet, and then use automation to manipulate things the way I want them to look.
-BP
www.peisch.com