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
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
Selected Articles