var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: To load data from Table to Excelfile
i have around 50 queries in sybase, which Support teams are running one by one & pasting the result in a excel file & then sends it to user.
We have a requirement where we need to write a unix script, which execute the query one by one & generate the excel sheet & send it to user.
I have completed half of the part, where i am executing query one by one & putting the result into a .txt file.
Do someone have handy script which convert the text file into excel file?
might be easier to select the data from within excel
From excel click
data, import external data, new database query
then select your odbc data source
use sqldbx tool
U can use sqldbx (free to downlaod) where u can write ur query and export the data to excel directly. Or u can use aquastudio. This is also very nice tool to export data in excel format.
Pat has the best approach.
But if you are attached to the script-and-post method, or you have no security implemented (and thus users are not allowed to connect directly to the database from Excel), and therefore the script method is demanded: create the output as a CSV file, not a text file, which loads directly into Excel. Use isql -s",".
Derek Asirvadem (Formerly DerekA)
Information Architect / Senior Sybase DBA
Copyright © 2009 Software Gems Pty Ltd
I answer questions from the Original Poster only. If you have a genuine question, as the moderators have requested, start a new thread.
Wrte an excel from PERL
On CPAN there is a PERL mod that dows what your seeking.
Look for the write readme file for a description.