If I run the sql file in the Interactive SQL GUI, it outputs the excel file perfectly. But when I run it using the command line isql, it throws me a "Syntax error near keyword 'output' " error message.
I tried using the -o option in isql to output the results, but then I have to look at setting up Excel macros to convert this to xls. I would prefer to avoid this route especially since Sybase does seem to have this 'output to' option. Just how do you get it to work with command line isql though?