title: Import data from Excel into existing table
body: <p>I have a table <code>HRTC</code> in SQL Server. I want to import data which is in Excel into this table. But my Excel file does not have all the columns which match the <code>HRTC</code> table. Is there anyway I can do this?</p>
  
  <p>I am thinking something like in the import wizard</p>
  
  <pre><code>Insert into SQLServerTable Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 
  'Excel 8.0;Database=D:\testing.xls;HDR=YES', 
  'SELECT * FROM [SheetName$]')
  
   select column1, column2 from HRTC
  </code></pre>