title: Visual Basic.Net Insert multiple rows into a table
body: <p>I am a relative newbie and trying to insert multiple rows (and data from textboxes) from one table into another and am stuck.</p>
  
  <p>This SQL identifies the data to be inserted into the table</p>
  
  <pre><code>strsql = "SELECT '" &amp; textbox1.text &amp; "', '" &amp; Textbox2.text &amp; "', "
  strsql = strsql &amp; " a.TaskNum, a.StartDay, a.NumofDays FROM VETTimeLines as a"
  strsql = strsql &amp; " ORDER BY a.StartDay"
  </code></pre>
  
  <p>I started out along the lines of -> Insert into StudentProgram Values() code shown above, after 3 days of trying I now look forward to your advice.</p>
  
  <p>Many thanks in anticipation
  Peter</p>