Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009

    Unanswered: To load data from Table to Excelfile

    Hi All,

    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?

  2. #2
    Join Date
    May 2005
    South Africa
    Provided Answers: 1
    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

  3. #3
    Join Date
    Apr 2009

    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.


  4. #4
    Join Date
    Mar 2009
    Sydney, Australia
    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.

  5. #5
    Join Date
    Mar 2007

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts