Error: The Microsoft.ACE.OLEDB.12.0 provider is not registered when ClosedXML.Excel dll not imported for application used to import Excel Data in ASP.Net

Question

which type of dll need to put in bin server so that The 39MicrosoftACEOLEDB12039 provider is not registered on the local machineproblem solved I

manoj150 · Accepted Answer

No need to worry about only oledbthere is a lot of other method are used to upload xlsx filesimportHere is the headerusing ClosedXMLExcelInstall ClosedXMLExcel dll from nugetHere is the code  string filePath  ServerMapPath34ContentMailMarketing34  PathGetFileNameflexcelPostedFileFileName        flexcelSaveAsfilePath        Open the Excel file using ClosedXML        using XLWorkbook workBook  new XLWorkbookfilePath                    Read the first Sheet from Excel file            IXLWorksheet workSheet  workBookWorksheet1            Create a new DataTable            DataTable dt  new DataTable            Loop through the Worksheet rows            bool firstRow  true            foreach IXLRow row in workSheetRows                            Use the first row to add columns to DataTable                if firstRow                                    foreach IXLCell cell in rowCells

Error: The Microsoft.ACE.OLEDB.12.0 provider is not registered when ClosedXML.Excel dll not imported for application used to import Excel Data in ASP.Net

Hi manoj150,

The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.

System.InvalidOperationException: The Microsoft.ACE.OLEDB.12.0 provider is not registered

Company

Explore

Follow us

Contact Us