Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2004
    Posts
    3

    Unhappy Unanswered: Sybase and text/excel file

    Hi

    How can I create a table in Sybase picking up data from a text/excell file. My sybase server is installed in an UNIX server. Is there any tool that can help. Or any other way - please help.

    Thanks

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    use bcp to load from a text file ; excel format is not supported

  3. #3
    Join Date
    Nov 2004
    Posts
    3

    BCP details

    I am new to Sybase and have not any idea how to work with bcp. Tried but its a live DB, so cannot experiment much.

    Would you please give a an example or some useful link.

    Thanks
    Last edited by Steave; 11-24-04 at 07:17. Reason: spelling

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    http://www.sybase.com/search_results...tr=BCP&qparse=

    & you might restrict to the product manual ...

    but the other link shows some example docs, too

  5. #5
    Join Date
    Nov 2004
    Posts
    3

    Lightbulb Done it

    Thanks a lot osy45

  6. #6
    Join Date
    Dec 2003
    Location
    FRANCE (Paris)
    Posts
    23
    With bcp it's possible to import csv files :

    bcp <table> in file.csv -c -t";" -S<...> -U<...> -P<...>


    mickael

Posting Permissions

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