title: C# Visual Studio 2010 - Import data from excel files into C# VS database
body: <p>I have a project in c# vs2010 with a SQL Server database (3 tables)</p>
  
  <p>I need to import data from two Excel files, one to fill <code>CapitalPlan</code>, the other to fill <code>MilestoneData</code> tables respectively.</p>
  
  <p>I have been advised to fill this using VS 2010 tools (see view in erd diagram link), without using code in any of my C# forms - I just need to fill it with data so I can create and test some queries.</p>
  
  <p>Please can anyone advise how I may go about doing this? Maybe creating a function in vs... I'm not entirely sure</p>
  
  <p>Much appreciated</p>
  
  <p>Images below may help:</p>
  
  <p>ERD diagram</p>
  
  <p><a href="http://i1186.photobucket.com/albums/z373/barbsbargainsltd/erd_zps059d4dac.jpg" rel="nofollow">http://i1186.photobucket.com/albums/z373/barbsbargainsltd/erd_zps059d4dac.jpg</a></p>
  
  <p>Excel CapitalPlan (to fill capital plan table)</p>
  
  <p><a href="http://i1186.photobucket.com/albums/z373/barbsbargainsltd/capplan_zps31bc1d6a.jpg" rel="nofollow">http://i1186.photobucket.com/albums/z373/barbsbargainsltd/capplan_zps31bc1d6a.jpg</a></p>
  
  <p>See comments for addition image (I don't have enough rep yet)</p>