title: How to avoid OLEDB converting "."s into "#"s in column names?
body: <p>I'm using the ACE OLEDB driver to read from an Excel 2007 spreadsheet, and I'm finding that any '.' character in column names get converted to a '#' character.  For example, if I have the following in a spreadsheet:</p>
  
  <pre><code>Name        Amt. Due        Due Date
  Andrew      12.50           4/1/2010
  Brian       20.00           4/12/2010
  Charlie     1000.00         6/30/2010
  </code></pre>
  
  <p>the name of the second column would be reported as "Amt# Due" when read with the following code:</p>
  
  <pre><code>OleDbConnection connection = new OleDbConnection(
      "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=MyFile.xlsx; " +
      "Extended Properties=\"Excel 12.0 Xml;HDR=YES;FMT=Delimited;IMEX=1\"");
  OldDbCommand command = new OleDbCommand("SELECT * FROM MyTable", connection);
  OleDbReader dataReader = command.ExecuteReader();
  System.Console.WriteLine(dataReader.GetName(1));
  </code></pre>
  
  <p>I've read through all the documentation I can find and I haven't found anything which even mentions that this will happen.  Has anyone run into this before?  Is there a way to fix this behavior?</p>