title: External table not in the expected format
body: <p>I kept getting External table not in the expected format and I don't know why. I tried both 2003 and 2007 connection string techniques, but still it didn't work.</p>
  
  <p>Below is my code. Thanks!</p>
  
  <pre><code>string filename = Path
              .GetDirectoryName(System.Reflection.Assembly
              .GetExecutingAssembly().GetName().CodeBase) +
              "\\acu.xls";
          filename = filename.Substring(6);
  
          //string connString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
              //"Data Source=" + filename + ";" +
              //"Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1;\"";
  
          string connString = "Provider=Microsoft.ACE.OLEDB.12.0;" +
              "Data Source=" + filename + ";" +
              "Extended Properties=\"Excel 12.0;HDR=YES\"";
  
  
          OleDbDataAdapter dbAdapter = new OleDbDataAdapter("Select * from [Sheet1$]", connString);
  
          DataSet myDataSet = new DataSet();
          dbAdapter.Fill(myDataSet, "ACUList");
  
          DataTable dataTable = myDataSet.Tables["ACUList"];
  
          var query = from r in dataTable.AsEnumerable()
                      select new
                          {
                              Firstname = r.Field&lt;string&gt;("FIRSTNAME"),
                              CardNo = r.Field&lt;string&gt;("CARDNO")
                          };
  
          foreach (var item in query)
          {
              Console.WriteLine(item);
          }
          Console.ReadKey();
  </code></pre>