title: Excel data column name changing when loaded into dataset using Microsoft.ACE.OLEDB.12.0
body: <p>I have an excel sheet with 18 columns. In that 5 columns have same column name <code>CALL_REASON</code>. But when i load that excel sheet into a dataset using Microsoft.ACE.OLEDB.12.0. The column names in dataset are changed for the columns which had same name. it is getting loaded as <code>CALL_REASON,CALL_REASON1,CALL_REASON2,CALL_REASON3,CALL_REASON4</code>. They are present in excelsheet as <code>CALL_REASON,CALL_REASON,CALL_REASON,CALL_REASON,CALL_REASON</code></p>
  
  <pre><code>String properties = "Excel 8.0; HDR=YES; IMEX=1;";//properties set for connection to excel
  string sSourceConstr = @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\uploads\" + fileName + ";Extended Properties=\"" + properties + "\"";
  
  sSourceConnection = new OleDbConnection(sSourceConstr);//creating the OLEDB connection
  try
  {
      //select statement to select data from the first excel sheet
      string sql = string.Format("Select * FROM [{0}]", "Sheet1$");
  
      //commands to fill the dataset with excel data
      OleDbDataAdapter excelAdapter = new OleDbDataAdapter();
      OleDbCommand command = new OleDbCommand(sql, sSourceConnection);
      sSourceConnection.Open();
      excelAdapter.SelectCommand = command;
      excelAdapter.Fill(surveyItemDetails, "ExcelDataTable");
  }
  </code></pre>