The excel version I am using is Microsoft excel 2007

I do see this provider info in the connection string in the Excel Connection Manager

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=spreadsheet.xls;Extended Properties="Excel 12.0;HDR=YES";

I am using the Excel Source from the tool box and mapping to...

Thanks Andre for the response , I have tried to first open the Excel file and then do the extraction , it did work fine , but I would have...

Thanks Everyone for the quick Response , Is there a way to import data into Sql Server Table from an excel File use BCP Utility, Bulk Copy or Bulk Insert....