title: Append data to SQL table from Excel
body: <p>I have users entering in varying rows of data in an excel template, depending on the client data being entered this could be anything from 1 row to 400 rows spanning from columns B to L.</p>
  
  <p>Is there a way in VBA to create a bulk insert into a SQL table where, as the user enters the data and then hits an upload button VBA can execute a macro to write back to the table?</p>
  
  <p>I have done something similar before with a bulk insert on a .csv but was wondering if there is something a little more slick straight out of VBA code.</p>
  
  <p>Many Thanks</p>