Microsoft OLEDB 12.0 not working with Excel 2016 (rows more than 65000)

The Microsoft OLEDB 12.0 works fine in 2007 fetching rows more than 65000 rows with select query in VBA with named range.

This doesn't works with Excel 2016 until we keep the data with header in first row and select query with Sheet$ . select query fails fetching data more than 65000 with name range in Excel 2016.

0 answers