title: Importing Excel files with a large number of columns header into mysql with c#
body: <p>i just was just wondering, how do i import large excel files into mysql with c#? My coding experience isn't great and i was hoping if there's anyone out there who could give me some rough idea to start on it. So far, i was able to load excel files into datagridview with the following codes:</p>
  
  <pre><code>string PathConn = " Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + pathTextBox.Text + ";Extended Properties =\"Excel 8.0;HDR=Yes;\";";
  OleDbConnection conn = new OleDbConnection(PathConn);
  conn.Open();
  OleDbDataAdapter myDataAdapter = new OleDbDataAdapter("Select * from [" + loadTextBox.Text + "$]", conn);
  table = new DataTable();             
  
  myDataAdapter.Fill(table);    
  </code></pre>
  
  <p>but after that, i don't know how i could extract the information and save it into mysql database. Assuming i have a empty scheme created before, how do i work on uploading excel files into mysql? thanks.                   </p>