Link to home
Start Free TrialLog in
Avatar of mainrotor
mainrotor

asked on

need help troubleshooting an error I am getting when opening an Excel spreadsheet from my WPF application

Hello Experts,
I need help troubleshooting an error I am getting in my WPF.Net application with C#.Net code-behind.

The error I get has to do with the OLEDB connection I am using to try to access and read an Excel (.xlsx) spreadsheet from my application (see error below):

ERROR I AM GETTING:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Here is the code I use to try to access and read the Excel spreadsheet from within my application:
        OleDbConnection conProds;
        conProds = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + "C:\\Users\\gizmo\\Documents\\RR\\ISDQuoter\\Products.xlsx" + ";"); 
       conProds.Open();

Open in new window


Please let me know how to fix this issue.

Thank you,
mrotor
ASKER CERTIFIED SOLUTION
Avatar of Tapan Pattanaik
Tapan Pattanaik
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mainrotor
mainrotor

ASKER

Tapan,
I will try your suggestion and keep you posted.

thank you,
mrotor