[dba-SQLServer] Bulk insert

Stephen Hait shait at mindspring.com
Tue May 1 09:22:44 CDT 2007


Could you possibly use DTS instead of BCP? It should allow you to
specify your text qualifier.

Stephen

On 5/1/07, JWColby <jwcolby at colbyconsulting.com> wrote:
> I am trying to to use the bulk insert to pull csv file data in to a table.
> It appears that I have everything except for the fact that the data is
> enclosed in "" - "SomeData".  This is common in CSV files in order to "wrap"
> commas which would otherwise be interpreted as a field delimiter.  Bulk Copy
> has a Line Terminator and a Field terminator as a parameter but I do not see
> anyplace to specify what is known as a "Text qualifier" (the " surrounding
> the data).
>
> Is there ANY way to do this?  CSV files are very common and text qualifiers
> are so common that the import / export wizard allows you to specify them.
> Surely bulk insert must understand them.
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



More information about the dba-SQLServer mailing list