Search code examples
exceloledb

Could inner excel row properties could affect oledb visibility?

ader doesn't show the first row of xls file, selected with select * from [sheet$]. Probably some inner excel row properties could affect oledb visibility?

Solution

  • Extended Properties=""Excel 12.0; HDR=No; IMEX=1;" this property tells OLEDB to ignore the first row (it treats it as header).