3 Replies Latest reply: Jul 17, 2018 4:48 AM by xxxxx yyyyy RSS

    Data loading not properly from Notepad

    xxxxx yyyyy

      data in Note pad like therse..

       

      LineNO        EmployeeID     StartDate                EndDate                    BaseSalary

      1                   1.00                1/1/2008 00:00:00   31/12/2008 00:00:00 100000    

      2                   1.00                1/1/2009 00:00:00   31/12/2009 00:00:00 110000    

      3                   1.00                1/1/2010 00:00:00   31/12/2010 00:00:00 120000    

      4                   1.00                1/1/2011 00:00:00   31/12/2011 00:00:00 130000    

      5                   1.00                1/1/2012 00:00:00   31/12/2012 00:00:00 140000    

      6                   1.00                1/1/2013 00:00:00   31/12/2013 00:00:00 150000    

      7                   1.00                1/1/2014 00:00:00                                      160000    

      8                   2.00                1/4/2010 00:00:00   31/12/2010 00:00:00 35000     

      9                   2.00                1/1/2011 00:00:00   31/12/2011 00:00:00 36050     

      10                 2.00                1/1/2012 00:00:00   31/12/2012 00:00:00 37132

       

       

       

      at the time of loading , Iam getting like these..

       

      LineNO  EmployeeID          StartDate        EndDate    BaseSalary

      1                   1.00                1/1/2008         00:00:00   31/12/2008         

      2                   1.00                1/1/2009         00:00:00   31/12/2009             

      3                   1.00                1/1/2010         00:00:00   31/12/2010              

      4                   1.00                1/1/2011         00:00:00   31/12/2011               

      5                   1.00                1/1/2012         00:00:00   31/12/2012             

      6                   1.00                1/1/2013         00:00:00   31/12/2013

      7                   1.00                1/1/2014         00:00:00    160000    

      8                   2.00                1/4/2010         00:00:00   31/12/2010      

      9                   2.00                1/1/2011         00:00:00   31/12/2011     

      10                  2.00                1/1/2012        00:00:00   31/12/2012

       

      How could i solve these.