Execute Query and export to .xls using command line using TOAD
Hello I would like to execute a query from the command line and have this queries results exported to an.xls file using Quest's TOAD. I've read Toad's documentation about "exporting queries from the command line", but this is not working for me.
What I am doing right now is from the command line I type in
C:\toad.exe connect=myname/mypass@db EXP=c:\exp_file.txt
just like what the documentation says to do; the location of "toad.exe" and "exp_file.txt" are not as shown, but are shortened for simplicity. What I think this should do is start up toad, which it does, execute the query i have defined in the exp_file.txt between the BEGINQRY and ENDQRY headers and export the result to an .xls file on my desktop. However, TOAD starts up when I execute this command and it just sits there doing nothing.
Can someone tell me what I am doing wrong? Thank you ahead of time.