Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33

    Post Unanswered: Importing CSV files in sybase tables

    Hi All,

    anybody knows how to import the CSV (comma seperated value) files into Sybase tables. I use Sybase 12.5 on windows platforms.

    Its kind of anybody replying instantly.

    Regards & Thanks
    Amit
    A friend in need is a friend in deed

  2. #2
    Join Date
    Jun 2003
    Posts
    140

    Re: Importing CSV files in sybase tables

    Use -r and -t options of BCP , i.e. row and column terminator.
    Terminators are the characters that separate data fields (field terminators). The row terminator is the field terminator of the last field in the table or file. Use the -tfield_terminator and -rrow_terminator command line options with the character format option (-c) to change the terminators from the command line.

    Remember to “escape” the backslash, if necessary, for your operating system command shell.
    for ex.

    bcp pubs2..publishers in pub_out -c -t , -r \r

  3. #3
    Join Date
    Dec 2003
    Location
    USA
    Posts
    33
    Thanx Perl that helped me
    A friend in need is a friend in deed

Posting Permissions

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