title: Import Excel data into an existing SQL Server 2005 table
body: <p>I'm trying to import some data from an Excel sheet into an existing SQL Server 2005 table.</p>
  
  <p>The table has the following columns:</p>
  
  <pre><code>Name, Surname, PhoneNumber ,Bill
  </code></pre>
  
  <p>and they are in the same order in the Excel sheet. </p>
  
  <p>I've never attempted such a thing before, but after searching for a while I was told I could use:</p>
  
  <pre><code>INSERT INTO table 
      SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
                               'Excel 8.0;Database=C:\temp\test.xls',
                               'SELECT * FROM [Sheet1$]')
  </code></pre>
  
  <p>Do I need to reference the column names from the Excel sheet to the SQL Server table columns?</p>
  
  <p>I'm certainly not a SQL guru, but would consider myself a good beginner. </p>
  
  <p>Can anyone help? </p>