Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2008
    Posts
    99

    Unanswered: sqlplus csv output

    Hi,

    I export data in csv format from sqlplus.
    however I can open this file properly as if I open excell file.
    when other users open this file with excell and see comma-dotted data.

    Is there way to handle this problem

    Thanks
    Kind Regards

  2. #2
    Join Date
    Mar 2008
    Posts
    89
    If the data is comma-delimited, Excel needs to convert it into columns.
    I assume your Excel is already configured to do that automatically when you open it.
    The others need to convert it by clicking "Data" -> "Text to Columns..." in the menu. Then they choose the comma as delimiter and off they go.
    "My brain is just no good at being a relational Database - my relations suck real bad!"

  3. #3
    Join Date
    Dec 2008
    Posts
    99
    Hi,
    Problem is that each user must know this but they are not supposed to know.
    Is there another way to handle this
    Kind Regards

  4. #4
    Join Date
    Mar 2008
    Posts
    89
    You could deploy a macro to all user Excel versions, that handles the import of csv values automatically when opening the file?
    "My brain is just no good at being a relational Database - my relations suck real bad!"

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Or do not make a csv file, but a slk file which is understood by excel. See the following llink.

    Ask Tom "Owa_sylk utility"

    An sylk file can not have multiple sheets, but supports formatting, data type and is a microsoft standard.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  6. #6
    Join Date
    Dec 2008
    Posts
    99
    Hi,
    I donot know whether I have a another chance.Because I export csv from sqlplus.

    You are advising to create owa.package? actually coding plsql package.

    Kind Regards

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink Html

    Another option is to export the file in xml format:
    Code:
    SET MARKUP HTML ON
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  8. #8
    Join Date
    Mar 2008
    Posts
    89
    Quote Originally Posted by beilstwh
    Or do not make a csv file, but a slk file which is understood by excel. See the following llink.

    Ask Tom "Owa_sylk utility"

    An sylk file can not have multiple sheets, but supports formatting, data type and is a microsoft standard.
    Very nice. I haven't tried this package, but I think this is the best approach you can take, if you have no other reason to keep the csv format.
    "My brain is just no good at being a relational Database - my relations suck real bad!"

Posting Permissions

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