Bulk Insert for data with quotes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mark (Mark_at_discussions.microsoft.com)
Date: 09/23/04 

Date: Wed, 22 Sep 2004 23:25:04 -0700

Hi
I am new to DTS, I use bulk insert to load a csv file which has all its
character (as opposed to numeric) data in double quotes. But the bulk insert
takes the data into the table along with the quotation marks. I know you can
do this easily in Transform Data Task, but for lot of records I want to use
bulk insert. How can I get bulk insert to recognise double quotes?

Relevant Pages

  • Re: Cannot fetch a row from OLE DB provider "BULK" for linked serv
    ... In the destination table - before I forget to mention it - there is a column ... BULK INSERT DataGL.dbo. ... Regarding quotes in the data file, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.programming)
  • Re: Bulk Insert
    ... and the error message says: ... Error: Bulk Insert fails. ... file with comma as field delimiter, and quotes are obviously not part ... A format file for the above would look ...
    (microsoft.public.sqlserver.tools)
  • Bulk Insert Doesnt recognise double quotes
    ... I use bulk insert to load data from a csv file to sql server db. ... character data in the file is surrounded with quotes. ...
    (microsoft.public.sqlserver.dts)
  • On to Bulk Insert issues
    ... Bulk load data conversion error (type mismatch or invalid character for ... The bulk load failed. ... tell MS SQL Server that the fields are optionally enclosed by quotes. ...
    (comp.databases.ms-sqlserver)
  • Re: Simple Bulk Insert
    ... I try to avoid quotes in BCP since it can be a pain, ... Using BCP When Data is in Quotation Marks ... This article describes how to customize the bulk copy program format ...
    (microsoft.public.sqlserver.server)