Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009

    Question Unanswered: How export a query to file cvs ?


    My name is German, I need know How i can export the result of a query to a file cvs or exel.

    I am new working with db sybase.

    Thank you

  2. #2
    Join Date
    Mar 2008
    Dear German
    You can put the result of the query in some temporary table and take the bcp out of the table.
    for example
    select * into xyz from abc into xyz where ......
    bcp out <path of the file> -U<user name> -P<password> -n -t ',' -r '|'

    where -t for column sepratror
    -r row seprator

Posting Permissions

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