Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Question Unanswered: BCP Format file.

    how can i from a text file to copy in data to a table,
    but the field in the txtfile is less than the fields in the table,
    how can i set the format file to copy in data?????

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    You can avoid the format file if you have field separators in your file, even if the field length is smaller in file than table column width.

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    ... or using -c (character mode) or -n (native mode)

  4. #4
    Join Date
    May 2004
    Posts
    35
    what about image datatypes and text datatypes? can i use bcp to place it on a text file? text datatypes may have ~r or ~n right?

  5. #5
    Join Date
    May 2004
    Posts
    35
    guess i have to settle myself to native format

Posting Permissions

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