title: How to Insert New CSV Data into Existing Table (Microsoft SQL Server)
body: <p>Once a month we receive .csv files from one of our software providers which contains useful data. The data contains all of the previous months data. There are quite a few columns that need to be renamed and it's faster and easier to do this is SSMS.</p>
  
  <p>So, I have created a table with these headings and inserted the data. When the new month comes around, I want to remove the previous months data with; </p>
  
  <pre><code>TRUNCATE TABLE test_data_1;
  </code></pre>
  
  <p>I then want to load in the new months .csv file against the existing table with the existing headings, which prevents me having to rename them all again. </p>
  
  <p>Is this achievable or will I just have to DROP the table and re-upload a flat file each time?</p>
  
  <p>Thanks!! </p>
  
  <p>Ben</p>