Open with OLEDB xlsx file that contains Image and blank rows

Viewed 20

I try to import data from xlsx file using OLEDB, but it occurs an error.

Excel look like this

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?

0 Answers
Related