Excel Read Data From Excel

See more:

ASP.NET

In my application i am reading data from excel and storing in DataTable object
code is as below

string excelFilePath = "D:\\sunny1.xls";
            string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelFilePath + ";Extended Properties=Excel 12.0;";
            OleDbConnection excelOledbConObj = new OleDbConnection();
            excelOledbConObj.ConnectionString = connectionString;
           
            DataTable excelDataTable = new DataTable();
            excelOledbConObj.Open(); 
OleDbCommand oledbCmdObj = new OleDbCommand();
            oledbCmdObj.Connection = excelOledbConObj;
            try
            {
                
                OleDbDataAdapter oldataAdapterObj = new OleDbDataAdapter(oledbCmdObj);
                oledbCmdObj.CommandText = "Select * from [" +sb1.ToString()+"]";

                oldataAdapterObj.Fill(excelDataTable);
            }
            catch (OleDbException ex)
            {
                Response.Write(ex.Message);
            }

and my excel data is as follows:-

EmpCode	Title<br />
999312	mr<br />
As9991  miss<br />
when i execute my application  my datatable have data as follows<br />
999312	mr<br />
NULL  miss<br />

why i am getting null value over here

can anyone help me out here. I believe its happen due the different type of data in my EmpCode column