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