2
Answers

.xls excel file not inserted all rows in database

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)