I have Excel File with 100000 rows , I am uploading file in database using
OleDb provider(Provider=Microsoft.ACE.OLEDB.12.0 )
when i use .xls file then all data inserted in database successfuly , whenever i use .xlsx extension of Excel file
then only 26659 rows inserted in database out of 1000000.