Urgent help for writing text file to excel using macro coding

[praveenvinay]

Hi,

I have to complete one task today itself..
My requirement is have to select only select statement from the query and paste into excel....

The following is my input
more stmt
DPDTA // endif;
// Get the DC for this PO's destination so we can retrieve the
// filter criteria for that DC.
exec sql select vinayagar, Arun, Prathiban
into :vinayagar, :arun, :parthiban
from pravin
where arun = 100;
// Test the PO filter criteria
if not %open(saran);
More stmt

OUTPUT should be as follows in excel.....
Field name File Name where
vinayagar praveen arun = 100
Arun
Parthiban


Please need to complete by today itself so help me out to write program for this .... Please let me know if you require any more details....