I am trying to read an excel-sheet containing a pivot table generated by macros with the following connection string:
Extended Properties="Excel 8.0;HDR=NO;";
I don't know why, but by changing the provider to
Provider=Microsoft.ACE.OLEDB.12.0, data is read correctly.
the fill dataset is slower, i but I got what i'm looking for thanks