title: Trouble uploading txt file into SQL from Java
body: <p>I know I'm probably missing something really obvious but I'm having trouble with a text file uplopad into an MSSQL server from a Java app running on a windows client.  It's taking the multiple lines and loading them all into one record intead of generating a new record for each line. </p>
  
  <p>The text file is generated by the java app using the System.lineSeparator() to seperate the lines and the output displays fine inspecting the file in notepad and the code to upload the txt file as below</p>
  
  <pre><code>        File file = new File(fileName);
          FileInputStream fis = new FileInputStream(file);
          PreparedStatement pstmt = con1.prepareStatement("insert into " + 
                  tableName + "(" + columnName + ") values (?)");
          pstmt.setAsciiStream(1, fis, (int) file.length());
          pstmt.executeUpdate();
          fis.close();
  </code></pre>
  
  <p>I've tried subing the System.lineSeparator() for \r\n but had no luck their either... any thoughts would be appreciated</p>