Bulk Insert Text Qualifer

• Conrad Meertins

  Grasshopper

  Points: 17

  More actions

  August 7, 2006 at 1:49 pm

  #367061

  I am using Bulk Insert to Import a Tab Delimeted file that contains quotes(") ion some of the fields.

  Example 1: """"This is a just a test."""

  Results should be "This is just a test"

  Example 2: """This is only a test"" and nothing more"

  Results should be:"This is only a test" and nothing more.

  Now.

  If I use DTS manual import process and select "Double Quotes" as the Text Qualifier, I would get the results expecting.

  Question: Is there a way or a switch in Bulk Insert  that I could use to get rid of the extra quotes?

  Thanks

  Conrad...

   

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  August 10, 2006 at 6:49 am

  #654286

  Have a look at this... It may help.

  http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.programming/2004-04/4701.html

  -Luke.

  To help us help you read this[/url]For better help with performance problems please read this[/url]