First, you may install 2007 Office System Driver: Data Connectivity Components. from here -> https://www.microsoft.com/en-us/download/details.aspx?id=23734
Then after restarting your machine, you can change your target AnyCPU to x86 or x64 and try it. I was having same issue with Office 365 with 2016, I changed target build option to 86 and it was working perfect.
To change that go to properties by right click on project in solution explorer section -> Build -> Platform Target (Here choose x86 or x64)
I hope that help you to fix your problem.