Excel System.Data.OleDb.OleDbException: No value given for one or more required parameter

This Error comes when Excel connection string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1" " contains 'HDR=Yes' and you are using F1,F2, F3, etc in your select statement.

Solution:
if your Excel connection string contains 'HDR=Yes' then valid columns would be in the first row of the specified Worksheet (or Range). Otherwise, (HDR=No) the column names default to F1, F2, F3, etc.