I try to import data from xlsx file using OLEDB, but it occurs an error.
I'm using
sqlConn.ConnectionString = 'Data Source='+ path +';Extended Properties="Excel 12.0 XML;HDR=YES;IMEX=1;"'
sqlConn.Open();
var sqlStm1 = "SELECT * FROM `data$A15:ZZ`";
error message is
external table is not in the expected format
It work when there's only blank rows or image without blank rows.
Anyone have an idea how to fix this?