title: Creating an Excel Sheet with ADO.NET (OleDb) --> What DataTypes are Supported?
body: <p>I try to create an Excel (2003) Sheet with ADO.NET (OleDb).</p>
  
  <p>I was able to create the Sheet with an OleDbCommand:</p>
  
  <pre><code>var cnnString = "Provider=Microsoft.Jet.OLEDB.4.0;...";
  var cnn = new OleDbConnection(cnnString);
  var cmd = cnn.CreateCommand();
  cnn.Open();
  cmd.CommandText = "CREATE TABLE MySheet (ID char(255), Field1 char(255))";
  cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>That works as expected.</p>
  
  <p>Here my Question:
  What DataTypes (like char(255)) are Supported by Excel within the CREATE TABLE command? I did google but didn't find any documentation or hints.</p>
  
  <p>Thanks for your help.</p>