Skip to Content
0

crystal report enterprise excel 2016

Jan 27, 2017 at 02:03 PM

287

avatar image
Former Member

We have just installed EXCEL 2016 and are using Crystal report for enterprise. We are having connectivity problems. Is there someone who can help me? Thanks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Brian Dong Jan 27, 2017 at 05:54 PM
0

Hi Bruce,

I ran into something similar a couple of days ago. The problem is I'm guessing MS Office is 64 bit where Crystal is 32 bit so Crystal won't be able to connect to your Excel file because of that.

I've been able to get around this by installing the 32 bit Access 2010 engine. The key though is to install it from a command line with the /passive switch. If you install if by running the EXE it will fail because it checks to see if the 64 bit Office is installed. Running the install form a command line for some reason bypasses this check and installs the engine fine.

You can download the engine here:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Make sure you open a Command window as Administrator and you should be fine. This only works with the Access 2010 engine, the 2013 didn't work.

Check the solution here:

https://social.msdn.microsoft.com/Forums/en-US/8f501ab5-7690-46fc-9799-33109f03078b/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=adodotnetdataproviders

Good luck,

Brian

Share
10 |10000 characters needed characters left characters exceeded