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

News Knowledge Base
1

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.