Import Excel 2007 from asp.net steps
Installed - AccessDatabaseEngine
connection sting should be like this....
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\excel\ExcelImport_8-2009.xlsx;Extended Properties="Excel 12.0 Xml;HDR=NO;IMEX=1;""
Hurray!!!!!!!!!!!!!!!!!
Here in connection string HDR=No means header row is not indication column name and HDR=YES means yes first row in excel sheet indicates columns.