Can someone tell me which driver or library I might include in TP to allow me to use the 'spool' command that I use in SQLPlus?
...Am I asking too much?
Disclaimer: I am forever a newbie!
Is what you want to do...
1) Open a flat file for output = SPOOL filename.txt
2) Write something to the file = SELECT * FROM dual;
3) Close the file = SPOOL OFF
If so, look up the VBA help for the "Open Statement".
Open "C:\myfile.txt" For Output As #1
Print #1, "Hello world"
Thanks but the spool of a sql query is more what I was aiming for.
This has been resolved.