Excel to DataTable problem- not reading data as it is.

venkates.99 0 Tallied Votes 151 Views Share

I have Excel like

EmpId EmpName ProjName Date JiraId Thursday, March 01, 2012

1 test3 Project Name 4/11/2012 1810 5
2 test4 Project Name2 4/11/2012 1810 6

when I read data to DataTable the result will be like

EmpId EmpName ProjName Date JiraId 40969

1 test3 Project Name 4/11/2012 12:00:00 AM 1810 5
2 test4 Project Name2 4/11/2012 12:00:00 AM 1810 6

  1. last column name 'Thursday, March 01, 2012' changed to '40969'
  2. value of Date(4/11/2012) is converted to DataTime(4/11/2012 0:00)

some can help me out here to get same values colummn name as well data.

Thanks in Advance
VVS

I have Excel like 

EmpId	EmpName	ProjName	    Date 	   	Thursday, March 01, 2012
1	     test3	 Project Name	  4/11/2012		      5
2	     test4	Project Name2	  4/11/2012	          6


when I read data to DataTable the result will be like 

EmpId	EmpName	ProjName	Date 	               	40969
1	test3	Project Name	4/11/2012  12:00:00 AM		     5
2	test4	Project Name2	4/11/2012  12:00:00 AM   	     6


1. last column name 'Thursday, March 01, 2012' changed to '40969'
2. value of Date(4/11/2012) is converted to DataTime(4/11/2012 0:00)  

some can help me out here to get same values colummn name as well data.

Thanks in Advance 
VVS