Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Unanswered: help with csv file

    I am using UTL_FILE object in Oracle 9i to create an excell report.
    The excell report contains multiple sheets with it. Any one knows how to
    put the data extracted from tables into different sheets? I know how to
    do with the single sheet report, but no idea with the multiple sheets report. Very much appreciate your help!

    Kevin

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: help with csv file

    Originally posted by kyuan1
    I am using UTL_FILE object in Oracle 9i to create an excell report.
    The excell report contains multiple sheets with it. Any one knows how to
    put the data extracted from tables into different sheets? I know how to
    do with the single sheet report, but no idea with the multiple sheets report. Very much appreciate your help!

    Kevin
    Just curious...
    Why are you dumping Oracle data to CSV files
    when Excel via OBDC can "ingest" the data directly?

  3. #3
    Join Date
    Oct 2003
    Posts
    43

    what is OBDC ?

    and how can you use it to "ingest" the data directly into an Excel spreadsheet?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: what is OBDC ?

    Originally posted by chumpski
    and how can you use it to "ingest" the data directly into an Excel spreadsheet?
    Oops.
    ODBC - Open Data Base Connectivity
    Within Excel
    Data->Get External Data->Create New Query
    This "assumes" Oracle Client s/w is installed on the PC
    and it can connect to the target DB.

Posting Permissions

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