How to add Microsoft.ACE.OLEDB.12. 0 to my app’s installer . NET?

Question

Hi, I have an app that I programmed through Visual Studio 2017 using the Microsoft.ACE.OLEDB.12.0 to consult on files Excel and return data.

Now that I finished the project I had to publish. But when installing the application on a machine that does not have the Microsoft.ACE.OLEDB.12.0 installed, the application gives a connection error and does not perform the tasks properly.

So I’m wondering of any solution for this, some way to include this package in the application installer, or other way to fix the issue.

PS.: I used the Microsoft Office Access database engine 2007 installed on my machine to be able to use the application with the Microsoft.ACE.OLEDB.12.0. I don’t know if I would need to install this on the end-user machine or how to add this to the installer of app.

I was trying to add some reference or dll that solved the problem, but still could not.

Thanks for your help!

Answer 1

To try to access a database Access or a spreadsheet from Excel using the Visual Studio you need to install the following software:

Microsoft Access Database Engine 2010 Redistributable

2007 Office System Driver: Data Connectivity Components

Source

Source 2