title: How to Convert a CSV to a SQL Table WITHOUT 'Bulk Insert'
body: <p>I have a requirement to insert a CSV file into SQL, but am not permitted to use the Bulk Insert function...</p>
  
  <p>The CSV file contains thousands of lines, each of which contain 3 fields I.e</p>
  
  <p>John, Smith, 23</p>
  
  <p>And I would like to pass this into a SQL table (MSSQL2008) WITHOUT calling the 'Bulk Insert' function. The table would be the same structure as the CSV I.e it would contain 3 columns and a row for each line in the CSV.</p>
  
  <p>Does anyone know if this is at all possible?</p>