title: Import data from Excel to database in C#
body: <p>I need to import data from Excel to database with coding instruction.<br>
  But it gives me an error. "There is no row at position 0." in line 11.<br> In the meantime,should I replace my table name instead of "TABLE" in line 8??</p>
  
  <p>Below is my code :</p>
  
  <pre><code>public static DataTable ReadExcelWithoutOffice(string filePath)
  {
      var connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0;IMEX=1;HDR=YES;TypeGuessRows=0;FirstRowHasNames=true;ImportMixedTypes=Text\""; ;
      using (var conn = new OleDbConnection(connectionString))
      {
          conn.Open();
  
          var sheets = conn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
          using (var cmd = conn.CreateCommand())
          {
              cmd.CommandText = "SELECT * FROM [" + sheets.Rows[0]["TABLE_NAME"].ToString() + "] ";
  
              var adapter = new OleDbDataAdapter(cmd);
              var ds = new DataSet();
              adapter.Fill(ds);
              return ds.Tables[0];
          }
      }
  }
  </code></pre>