Hello, I have an application that I programmed through Visual Studio 2017 that uses Microsoft.ACE.OLEDB.12.0 to query Excel files and return data.
Now that I finished the project I had to publish. But when you install the application on a machine that does not have Microsoft.ACE.OLEDB.12.0 installed, the application gives a connection error and does not perform the tasks correctly.
So I'm wondering about some solution to this, some way to include this package in the application installer, or another way to fix the problem.
PS: I use the Microsoft Office Access database engine 2007 installed on my machine in order to use the application with Microsoft.ACE.OLEDB.12.0. I do not know if I would need to install this on the end user machine or how to add this to the app installer.
I was trying to add some reference or dll that solved the problem, but I still could not.
Thanks in advance for your help!