SQL Server Bulk insert of CSV file with inconsistent quotes

by

It isn’t possible to do a bulk insert for this file, from MSDN:

To be usable as a data file for bulk import, a CSV file must comply with the following restrictions:

  • Data fields never contain the field terminator.
  • Either none or all of the values in a data field are enclosed in quotation marks (“”).

(http://msdn.microsoft.com/en-us/library/ms188609.aspx)

Some simple text processing should be all that’s required to get the file ready for import. Alternatively your users could be required to either format the file according to the se guidelines or use something other than a comma as a delimiter (e.g |)

More Related Contents:

  1. Bulk Insert Partially Quoted CSV File in SQL Server
  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. Max Nbr of Months W/ No Activity in Past 12 Months
  17. Export from SQL Server to Excel
  18. hide/remove header and footer
  19. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  20. SQL Server: SELECT only the rows with MAX(DATE)
  21. Floor a date in SQL server
  22. LEN function not including trailing spaces in SQL Server
  23. How to view transaction logs in SQL Server 2008 [closed]
  24. Scheduled run of stored procedure on SQL server
  25. SQL Server ORDER BY date and nulls last
  26. tsql returning a table from a function or store procedure
  27. How to export data from SQL Server 2005 to MySQL [closed]
  28. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  29. Making an Entity Framework Model span multiple databases
  30. SQL Server 2008 Row Insert and Update timestamps

Leave a Comment