Help - Formatting Query Results

[whyzyrd]

I am trying to run a query on a Sybase dB with the results being written to a file. I want to be able to import this file into Excel. Does anyone know how to have SQL insert a fixed character (comma, semi colon, tab, etc) between each output column?

 

[KarthikBabu]

You may use "isql" with the "-s" option. The "-s" option defines the column separator. Use tab character as a column separator.

isql -U<username> -s&quot;<EnterTabHere>&quot;

Hope this helps you.

 

[whyzyrd]

thank you very much!!