title: How to export data from Excel spreadsheet to Sql Server 2008 table
body: <p>I want to import data from an <strong>Excel</strong> file - assume Excel 2003 / .xls - to Sql Server <strong>2008.</strong></p>
  
  <p>Have tried adding a linked server to the JET OLE DB Access driver, and of course it fails on the 64-bit machine.
  But when I try to drop the linked server while experimenting, there's another error saying that the linked server already/still exists!</p>
  
  <p>I have also tried changing the Excel driver to 32-bit (regedit tool) but am not sure if it's doing anything, same error is coming up!</p>
  
  <p>Some more details: 
  Say Table1 in Excel file has 5 columns.
  I want to map to Database.dbo.Table1 with 5 columns again, but with different names in table. 
  Is there a way to do even do such an import?</p>