title: MS Access/VB.Net - how can I insert rows from an Excel sheet data into MS Access table?
body: <p>My program is written in VB.NET and I have an excel sheet with only one column and type of column is Text. Now I want to add all the rows of excel sheet into MS Access table.</p>
  
  <p>My Access table has 5 columns, and I have to provide some static data for rest of fields. I can't let them empty as my table structure won't allow me to let them empty. they are mandatory.</p>
  
  <h2>My algorithm works this way</h2>
  
  <ul>
  <li>Read excel sheet data into a DataTable</li>
  <li>Loop to the end of all rows of DataTable</li>
  <li><p>Append text of each cell and some of my static information to make a query string</p>
  
  <pre><code>INSERT into TableName(c1,c2,c3) 
  values 
  (v1,v2,v3),
  (v1,v2,v3),
  (v1,v2,v3),
  (v1,v2,v3)
  ...
  ...
  (n1,n2,n3);
  </code></pre></li>
  <li>Execute this query</li>
  </ul>
  
  <p>But I got error in this query, Any suggestions?</p>