Page 1 of 1

sql query result to Excel

Posted: Tue Feb 27, 2007 7:38 am
by Stranger
Hello,
I have a problem, maybe anyone could help me. I need to put query results to excell file. Sql query works fine - I put it in Dataset loop, but how to put thes date to Excel, I don't know.
Thanks.

sql query result to Excel

Posted: Tue Feb 27, 2007 9:09 am
by Oleg
Just see this example. This task does a database loop and puts each fields of query into corresponding cell of Excell.
How to use :
1. Open excell document
2. Select necessary cell
3. Press Ctrl-Alt-[ for executing the task.

Don't forget to enable the task after importing. Also, you can assign another hot key to the task.