OLEDB Does not return first row of excel file
Try HDR=NO
in connection string
In your connection string you use the setting "HDR=YES"
, this means that the first row from your Excel file is treated by OleDb as the row containing the table's field names represented by the current sheet.
Using "HDR=NO"
indicates to OleDb that the first row contains data and the column names are automatically named, in progression. as "F1", "F2", "F3" etc....