title: In MySQL Workbench, using "Table Data Import Wizard" to import CSV creates empty table
body: <p>I am attempting to import a csv file into a MySQL table using the Table Data Import Wizard.  The sample section at the bottom of the Configure Import Settings screen looks fine and when I run the import, it says all of my entries were loaded successfully.  However, when I go to view the contents of the table, only the columns are there and none of my actual data loaded.  Does anyone know why this might be happening and how to correct it?</p>
  
  <p>EDIT:</p>
  
  <p>These are a few lines from my CSV file:</p>
  
  <blockquote>
    <p>STATION,STATION_NAME,ELEVATION,LATITUDE,LONGITUDE,DATE,MLY-TAVG-NORMAL,MLY-TMAX-NORMAL,MLY-TMIN-NORMAL,Average Temp,Max Temp,Min Temp
    GHCND:USW00094085,PIERRE 24 S SD US,647.4,44.0194,-100.353,201001,218,322,113,21.8,32.2,11.3
    GHCND:USW00094085,PIERRE 24 S SD US,647.4,44.0194,-100.353,201002,246,354,137,24.6,35.4,13.7
    GHCND:USW00094085,PIERRE 24 S SD US,647.4,44.0194,-100.353,201003,339,451,226,33.9,45.1,22.6
    GHCND:USW00094085,PIERRE 24 S SD US,647.4,44.0194,-100.353,201004,463,588,337,46.3,58.8,33.7
    GHCND:USW00094085,PIERRE 24 S SD US,647.4,44.0194,-100.353,201005,573,696,450,57.3,69.6,45</p>
  </blockquote>
  
  <p>Here are some images of the import process:
  <a href="https://i.stack.imgur.com/stKvz.png" rel="noreferrer"><img src="https://i.stack.imgur.com/stKvz.png" alt="Image1"></a></p>
  
  <p><a href="https://i.stack.imgur.com/e6yar.png" rel="noreferrer"><img src="https://i.stack.imgur.com/e6yar.png" alt="Image2"></a></p>
  
  <p><a href="https://i.stack.imgur.com/T2YYW.png" rel="noreferrer"><img src="https://i.stack.imgur.com/T2YYW.png" alt="Image3"></a></p>
  
  <p><a href="https://i.stack.imgur.com/br0if.png" rel="noreferrer"><img src="https://i.stack.imgur.com/br0if.png" alt="Image4"></a></p>
  
  <p><a href="https://i.stack.imgur.com/wCiix.png" rel="noreferrer"><img src="https://i.stack.imgur.com/wCiix.png" alt="Image5"></a></p>
  
  <p><a href="https://i.stack.imgur.com/xvLnH.png" rel="noreferrer"><img src="https://i.stack.imgur.com/xvLnH.png" alt="Image6"></a></p>
  
  <p>And here is what I see when I attempt to view the newly created table:
  <a href="https://i.stack.imgur.com/N13uj.png" rel="noreferrer"><img src="https://i.stack.imgur.com/N13uj.png" alt="Image7"></a></p>
  
  <p>Second Edit:</p>
  
  <p>Here is an image of my settings:</p>
  
  <p><a href="https://i.stack.imgur.com/O28yI.png" rel="noreferrer"><img src="https://i.stack.imgur.com/O28yI.png" alt="Settings"></a></p>
  
  <p>And here is an image of my CSV file showing line endings:</p>
  
  <p><a href="https://i.stack.imgur.com/5NzH8.png" rel="noreferrer"><img src="https://i.stack.imgur.com/5NzH8.png" alt="enter image description here"></a></p>