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

    Question Unanswered: How export a query to file cvs ?

    Hello

    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
    Posts
    96
    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 dbname..xyz 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
  •