Read more than 65535 rows from xlsx by ole db provider C#

When I run sql (select count(*) from table_name from xlsx file I result is 65535, but the excel sheet have more that 65535 rows. How fix it?
Connection string is :
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FileName + ";Extended Properties="Excel 12.0 Xml; HDR=No;IMEX=1"";
Use OleDBConnection and OleDbCommand

0 answers