Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    New York
    Posts
    45

    Unanswered: table output to xls format

    Hello,

    I have a procedure that create a table in a db with 15 columns based on input dates(start_date and end_date)

    After table is creaded I have to exported back to my dir as xls format

    Is there a way to do it via procedure???


    Thank you so mach for help


    Al

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    While running Excel
    Data->Import External Data->Import Data
    will allow you via ODBC to pull data dfirectly from Oracle into Excel
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2004
    Location
    New York
    Posts
    45
    Quote Originally Posted by anacedent
    While running Excel
    Data->Import External Data->Import Data
    will allow you via ODBC to pull data dfirectly from Oracle into Excel


    Thank you, but I really need it trough a procedure since later on I will create a bat file to execute that proc via sqlplus and output data to user dir.


  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What prevents YOU from using the search capabilities of this forum
    to obtain the solution to your problem that has been asked and answered here
    dozens & dozens of times?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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