[dba-SQLServer] Bulk insert

JWColby jwcolby at colbyconsulting.com
Tue May 1 08:28:54 CDT 2007


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
 



More information about the dba-SQLServer mailing list