Oledb Error: Oledb12.0 is not registered on local machine

anvina

SOLVED CLOSED ACTIVE ANSWERED
User: anvina
Posted: on Jul 23, 2018 04:46 AM
Forum: ASP.Net Web Forms
Replies: 7
Views: 4393

https://www.aspsnippets.com/Articles/Read-Excel-file-using-OLEDB-Data-Provider-in-C-Net.aspx

Regarding the above ....

I get error saying oledb12.0 is not registered in my local machine...

Also nowadays we have 16.0 ...

Which version of oledb provider do we use so that our code runs on all machines ols and new 4.0, 12.0, 15.0, 16.0???

Download FREE API for Word, Excel and PDF in ASP.Net

anvina

0 4

Reply
User: anvina
Replied: on Jul 23, 2018 08:15 AM
Modified: on Jul 23, 2018 08:16 AM
Report

// if the File extension is .XLSX using below connection string szConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; "Data Source='" + szFilePath + "';Extended Properties=\"Excel 12.0;HDR=YES;\"";

But in my code the connection string should be 12.0 ?? or the latest 16.0 ??? the provider

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Oledb Error: Oledb12.0 is not registered on local machine

Company

Explore

Follow us

Contact Us