title: Inserting bulk CSV files into the one SQL table [SQL Server 2008]
body: <p>I have multiple folders (six or so) with multiple .CSV files in them.  The CSV files are all of the same format:</p>
  
  <pre><code>Heading1,Heading2,Heading3
  1,Monday,2.45
  2,Monday,3.765...
  </code></pre>
  
  <p>Each .CSV has the same heading names [same data source for different months].  What is the best way to import these CSVs into SQL Server 2008?  The server does not have xpShell configured [for security reasons which I cannot modify], so any method which uses that (which I originally tried), will not work.</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>The CSV files are a maximum of 2mb in size and do not contain any commas (other than those required for delimiters).</p>
  
  <p>Any ideas?</p>