Bulk Insert Partially Quoted CSV File in SQL Server

by

Unfortunately SQL Server interprets the quoted comma as a delimiter. This applies to both BCP and bulk insert .

From http://msdn.microsoft.com/en-us/library/ms191485%28v=sql.100%29.aspx

If a terminator character occurs within the data, it is interpreted as
a terminator, not as data, and the data after that character is
interpreted as belonging to the next field or record. Therefore,
choose your terminators carefully to make sure that they never appear
in your data.

More Related Contents:

  1. SQL Server Bulk insert of CSV file with inconsistent quotes
  2. Turning a Comma Separated string into individual rows
  3. How to split a comma-separated value to columns
  4. How to export data as CSV format from SQL Server using sqlcmd?
  5. Import CSV file into SQL Server
  6. How to speed up bulk insert to MS SQL Server using pyodbc
  7. Import Multiple CSV Files to SQL Server from a Folder
  8. How to write UTF-8 characters using bulk insert in SQL Server?
  9. BULK INSERT with identity (auto-increment) column
  10. Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
  11. How can I import an Excel file into SQL Server? [closed]
  12. Bulk insert with text qualifier in SQL Server
  13. Cannot bulk load. Operating system error code 5 (Access is denied.)
  14. SQL Server – join rows into comma separated list
  15. How to Bulk Insert from XLSX file extension?
  16. How to create jobs in SQL Server Express edition
  17. Retrieve column definition for stored procedure result set
  18. Using varchar(MAX) vs TEXT on SQL Server
  19. Connecting to MS SQL Server with Windows Authentication using Python?
  20. TSQL Email Validation (without regex)
  21. How to find the port for MS SQL Server 2008?
  22. How to convert number of minutes to hh:mm format in TSQL?
  23. Temporarily disable all foreign key constraints
  24. SQL Server Dependencies
  25. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  26. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  27. Date range overlapping check constraint
  28. Conditional JOIN Statement SQL Server
  29. How do you deal with blank spaces in column names in SQL Server?
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment