Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Unanswered: output to a delimited file

    Is there a tool besides bcp that allows you to default the output in a delimited text file?
    I know you can have the output go to a grid or a text file but there are no delimits or am I missing something?
    By the way I am using Sybase.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya Chan,

    I'm not sure, why you don't want to use bcp. Using bcp it is quite simple to spool output to a delimited file

    bcp pubs2..authors out authors.out -c -t , -r \\r

    where -t is the field terminator
    and -r is the row terminator

    Cheers
    Willy

Posting Permissions

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