Bulk insert with text qualifier in SQL Server
You need to use a ‘format file’ to implement a text qualifier for bulk insert. Essentially, you will need to teach the bulk insert that there’s potentially different delimiters in each field. Create a text file called “level_2.fmt” and save it. 11.0 2 1 SQLCHAR 0 8000 “\”,” 1 wkt SQL_Latin1_General_CP1_CI_AS 2 SQLCHAR 0 40 … Read more