Vaishali Uchekar

Vaishali Uchekar

  • NA
  • 43
  • 18.8k

.xls excel file not inserted all rows in database

Apr 6 2016 7:21 AM
Hello,
 
 
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.

 


Answers (2)