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

Last Reply on Oct 16, 2017 05:27 AM By dharmendr

Posted on Oct 16, 2017 12:19 AM

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 on Oct 16, 2017 03:14 AM

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();

 


Posted on Oct 16, 2017 05:27 AM