title: Data from excel to sql tabel is importing in NULL values...why??
body: <p>I am importing data from excel to database.
  Following is schema of excel columns:
  below is the schema of db....and exactly matches with excel sheet data....................             </p>
  
  <pre><code>ID  integer                 
  organizationId  integer             
  categoryId  integer         
  attribute   text          
  Y1960       integer or null     
  Y1961       integer or null      
  Y1962       integer or null       
  Y1963       integer or null      
  Y1964       integer or null     
  Y1965       integer or null       
  Y1966       integer or null      
  Y1967       integer or null       
  Y1968       integer or null      
  Y1969       integer or null
  </code></pre>
  
  <p>And same is in database columns. I am using following code to retrieve 
  data of <code>first 10 columns  from excel</code> file. </p>
  
  <pre><code>OleDbConnection excelConnection =
                          new OleDbConnection(excelConnectionString);
  
          //Create OleDbCommand to fetch data from Excel
          OleDbCommand cmd = new OleDbCommand
          ("Select [ID],[organizationID],[categoryID],[parentID],[granularityLevel],[attribute],[Y1960],[Y1961],[Y1962],[Y1963],[Y1964],[Y1965] from [Details$]", excelConnection);
  
          excelConnection.Open();
          OleDbDataReader dReader;
          dReader = cmd.ExecuteReader();
  
          SqlBulkCopy sqlBulk = new SqlBulkCopy(connectionString);
          sqlBulk.DestinationTableName = "Data";
          sqlBulk.WriteToServer(dReader);
  </code></pre>
  
  <p>Problem is that data of <code>Y1960 column is not copied</code> into database table from excel file.
  Other columns are copied, but Y1960 is not copied. Only null value is available there.</p>