Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: How to do data import from a flat file ?

    Hi,

    How to load the data from a flat text file having delimiter ',' between columns ?
    Please give a sample query.

    Thanks,
    Sam

  2. #2
    Join Date
    Jan 2004
    Posts
    51
    you can use bcp command

    bcp database..table in file_name -Sserver_name -Uuser -c -t","

    I am assuming that you are loading data in all columns

Posting Permissions

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