results to a file.... .xls

[jpotucek]

Hi. We have one lonely little sybase database and I need to query a table or too and end up with the results in an excel file.

in T-SQL (Server Server and Query Analyzer) I know how to do it.. do a Select * from against the table and then save the results pane to .xls file. easy.

In the Sybase SQL anywhere Analyzer - I can do the select * from against the table but I can't figure out how to save the results pane to a file???? is there a way to do this programatically or can someone tell me how to do it through the GUI??

Thanks much!

 

[akenty]

If you can open up the DB in DBISQLC or DBISQLG, all you have to do is:

SELECT * FROM table_name;

OUTPUT TO 'c:\file_name.txt' FORMAT ASCII;

Then open up the text file in Excel and you should be good to go. Hope this helped.