title: SMSS: text qualifier in the Tasks > Data Import?
body: <p>I am trying to import a file, source <a href="https://pxnet2.stat.fi/PXWeb/pxweb/fi/Kuntien_avainluvut/Kuntien_avainluvut__2017/kuntien_avainluvut_2017_aikasarja.px/?rxid=444223df-f91c-4479-891f-5dcd50b983d2" rel="nofollow noreferrer">here</a> and selections <a href="https://i.stack.imgur.com/NwQSk.png" rel="nofollow noreferrer">here</a> (select all fields and select <code>"Pilkkueroteltu (otsikollinen)"</code> and then click <code>Jatka</code> to download), with two header rows, " as text qualifier, comma as a field separator and with UTF-8 format. I am unable to do this in Micsosoft Server SQL Management Studio. I will focus now only on the text qualifier where <code>"</code> does not work (only reading the first quote as text qualifier).</p>
  
  <p><a href="https://i.stack.imgur.com/XPFht.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/XPFht.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/K9sXt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/K9sXt.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/LbiVr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LbiVr.png" alt="enter image description here"></a></p>
  
  <p>where I am unable to specify the column separator, no idea why this is occurring.</p>
  
  <p><strong>Update 1</strong> </p>
  
  <hr>
  
  <p>Refresh/Reset buttons fixed the initial preview but I am getting the following preview error in the step <code>Select Source Tables and Views</code> later.</p>
  
  <p><a href="https://i.stack.imgur.com/sIsXI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sIsXI.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/Qm4vc.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Qm4vc.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/EcArE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EcArE.png" alt="enter image description here"></a></p>
  
  <p><strong>Update 2</strong></p>
  
  <hr>
  
  <p>I get the LocaleID error <code>The LocaleID 11 is not installed on this system.
   (SQL Server Import and Export Wizard)</code>. I am getting the same error despite <code>Locale/Code page</code> settings, what is causing this?</p>
  
  <p><a href="https://i.stack.imgur.com/l7JXq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/l7JXq.png" alt="enter image description here"></a></p>
  
  <p><strong>How to specify the text qualifier in the MSMM?</strong></p>