Re: Exporting reports to Excel

Douglas,

Some other alternatives:

1) Use CPYTOIMPF into a csv file on the IFS.
2) In an RPG programme, construct a  string (data structure) with comma's 
between the different field values, and either:
    a) write it to a flat file and use CPYTOSTMF;
    b) use the UNIX-APIs to write the output to the IFS directly.

You can extract data using SQL (STRQMQRY, for example) and copy it to the IFS.

For spool files: CPYSPLF and CPYTOSTMF, let the import wizard of Excel do the 
parsing.

I prefer the IFS over Client Access Data Transfer.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 27-7-05 at 13:40 Douglas W. Palme wrote:

>We are needing to export some of our reports to excel, I would appreciate 
>any feedback from those of you who have accomplished this either with rpgle 
>coding, third party tools, or something else that might be beneficial to us.