title: Excel cell-values are truncated by OLEDB-provider
body: <p>I'm using the OleDbConnection class to retrieve data from an Excel 2000/2003 workbook:</p>
  
  <pre><code>string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                            "Data Source=" + filename + ";" +
                            "Extended Properties=\"Excel 8.0;IMEX=1\";";
  
  OleDbConnection connection = new OleDbConnection(connectionString);
  connection.Open();
  
  // code to get table name from schema omitted
  
  var dataAdapter = new OleDbDataAdapter(string.Format("SELECT * FROM [{0}]", name),connection);
  var myDataSet = new DataSet();
  dataAdapter.Fill(myDataSet, "ExcelInfo");
  </code></pre>
  
  <p>Now it turns out that cells in the worksheet with length greater than 255 characters are being truncated. Is this a limitation in the Microsoft.Jet.OLEDB-provider, or is there something I can do about it?</p>
  
  <p>Anyone?</p>