OleDbConnection Error: unexpected error from external database driver (1) in ASP.Net

Last Reply one year ago By dharmendr

Posted one year ago

The spreadsheet was created from another softwar i got This Error When Import Excel  

But the same code and Same Excel Upload Successfully on offline but when online it is not working properly Geettting below Error

"unexpected error from external database driver (1).

OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Excel + "; Extended Properties= \"Excel 8.0;HDR=Yes;IMEX=1\";");
connection.Open();

 


Posted one year ago

when i upload .xlxs 

 

Error:- The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

 

 OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Excel + "; Extended Properties= \"Excel 12.0;HDR=Yes;IMEX=1\";");
       connection.Open();