title: Is it possible to fill a data table from another data table by SQL QUERY in VB.net
body: <p>I have a data table (<code>dtExcelSource</code>) which is filled from MS_Excel, using <code>oledb</code>.
  Now I have a second data table, which is structured (<code>SqlDbType.Structured</code>).</p>
  
  <p>My requirement is, to fill the second data table with few values from data table(<code>dtExcelSource</code>) using query or any other method.</p>
  
  <pre><code> MyConnection = New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &amp; filePath &amp; ";Extended Properties=""Excel 12.0 Xml;HDR=NO"";")
              MyConnection.Open()
              dtExcelSchema = MyConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing)
              Dim SheetName As String = dtExcelSchema.Rows(0)("TABLE_NAME").ToString()
              MyCommand = New OleDb.OleDbDataAdapter("Select * from [" &amp; SheetName &amp; "A5:F85]", MyConnection)
              DS = New System.Data.DataSet()
              MyCommand.Fill(DS, "SourceTbl")
              dtExcelSource = DS.Tables("SourceTbl")
              'dtExcelSource.Columns(0).DataType = GetType(Integer)
              dtExcelSource.Columns(0).ColumnName = "Serial"
              dtExcelSource.Columns(1).ColumnName = "Document A"
              dtExcelSource.Columns(2).ColumnName = "Contract A"
              dtExcelSource.Columns(3).ColumnName = "Subscriber A"
              dtExcelSource.Columns(4).ColumnName = "Document B"
         Return dtExcelSource
  </code></pre>
  
  <p>My second data table is having 15 columns, so want to insert each rows into second data table.</p>