2
Reply

.xls excel file not inserted all rows in database

Vaishali Uchekar

Vaishali Uchekar

Apr 6 2016 7:21 AM
314
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)