When Trying To Extract The Datatable From Excel With Execute Query Using OLEDB Not Reading All The Headers Of Excel

When trying to Extract the Datatable from Excel with Execute Query using OLEDB, why does it not read all the Headers of Excel?

Update the connection string to Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myOldExcelFile.xlsx; Extended Properties=“Excel 8.0;HDR=YES;IMEX=0”;

Reason: "HDR=Yes;" indicates that the first row contains columnnames, not data. "HDR=No;" indicates the opposite.