Search code examples
sqlcsvimportssmsqualifiers

SMSS: text qualifier in the Tasks > Data Import?

I am trying to import a file, source here and selections here (select all fields and select "Pilkkueroteltu (otsikollinen)" and then click Jatka 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 " does not work (only reading the first quote as text qualifier).

enter image description here

enter image description here

enter image description here

where I am unable to specify the column separator, no idea why this is occurring.

Update 1

Refresh/Reset buttons fixed the initial preview but I am getting the following preview error in the step Select Source Tables and Views later.

enter image description here

enter image description here

enter image description here

Update 2

I get the LocaleID error The LocaleID 11 is not installed on this system. (SQL Server Import and Export Wizard). I am getting the same error despite Locale/Code page settings, what is causing this?

enter image description here

How to specify the text qualifier in the MSMM?

Solution

  • I tried to replicate your scene. Very first, I had to delete first heading entry eg : "Kuntien avainluvut 1987-2016" Please see : sample image Column delimited is: ,

    Might not be accurate answer or different from something which you expect, but by applying above settings, I could import data through SSMS2012

    edit : based on comments.

    Here is the detailed steps : settings

    next, column delimiter

    next, you need to change column width of first column as it gave me data truncate errorchange column width next, success

    I have also got a dtsx package for the same, but I don't know how can I share it with you here.