Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

results to a file.... .xls

Status
Not open for further replies.

jpotucek

Technical User
Jan 26, 2005
144
US
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!
 
If you can open up the DB in DBISQLC or DBISQLG, all you have to do is:

Code:
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top