transfer data to file that too in excel file.

Hi Gurus,

I have a requirement to transfer data displayed into an output file that too in excel format. As per the syntax

TRANSFER dobj TO dset [LENGTH len]

[NO END OF LINE].

a single obj is supposed to be used in the syntax but the data displayed is not only from one internal table but there is another internal table from which data is also displayed.

How to transfer the entire thing into the file.

Please Reply.

Thanks,

Binay.