title: Fill one table with multiple OledbConnections C#
body: <p>I have an Excel file with Column A, Column B, Column C etc. and i have created an OledbConnection  </p>
  
  <pre><code>Con1 = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Extended Properties=\'Excel 12.0;';");
  </code></pre>
  
  <p>I have an other Access Database file with Column 1, Column B, Column 2 and i have created an other OledbConnection for .mdb file  </p>
  
  <pre><code>Con2 = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath + ";Persist Security Info=True;");   
  </code></pre>
  
  <p>I have created a DataTable "dt" in c# windowform and filling it using OledbDataAdapter(query, con). My "dt" table has<br>
  <code>Column B          Column A          Column C        Column 1           Column 2 
  Table 1(data)     Table 1(data)    Table 1(data)     Table 2(data)     Table 2(data)
  Con1              Con1              Con1               Con2             Con2</code> </p>
  
  <p>How can i use both connection in OleDbDataAdapter to fill and Which connection i use open() and close(). My both connection are separately working. My Reference column B is in Table 1.</p>