Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    7

    Unanswered: Copy comma separated text file into a Sql server table

    Hi

    I have a comma separated text file which I would like to import into a table. There are some columns which are enclosed in double quotes and others which are not. I've tried bcp - it didn't work.
    Can anyone help ? An example would be helpful.

    Thanks

    Yogesh

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: Copy comma separated text file into a Sql server table

    Use the DTS import wizard.
    Source: Text File, enter your text file location
    text qualifier: Double Quote {"}
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

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