on 01-14-2020 07:35 AM - edited on 05-20-2023 07:07 PM by caltang
How To: Enable Microsoft Excel Binary, Excel Legacy, Access (accdb extension) for In/Out tools
The following formats may not be found in the "File Format" option in the In/Out tools and require a separate installation from Microsoft:
Note that these drivers do not come with our installation but from Microsoft Office or separate driver installation.
Environment
Procedure
Please note that you need to install the Microsoft Access Database Engine 2010 Redistributable 32-bit driver. If you also need the 2016 Redistributable installed to support other software, then what you can do is to (and the order matters here) install the 2016 64-bit, and then install the 2010 32-bit.
You cannot install two different redistributables of the same "bitness" without errors, so this might involve uninstalling a driver or two first.
Team,
I have installed, but also unable to read.
same error showing.
A tip from another Community user:
If you get messages saying that you cannot install the Microsoft Access Database Engine 2016 Redistributable of either "bitness" because you have the other "bitness" Office products currently installed and at the bottom of these messages they mention Click-to-Run Extensibility Component, this link and this link may be helpful to you.
I can confirm LisaL's very good comment that the 2010 version of the Microsoft Access Database Engine must be used and not the 2016 version in order for .xlsb files to work in Alteryx. I first installed the 2016 version and it didn't work. After installing the 2010 version, it worked. Thanks Lisa!
Confirmed: installed 2010 version and it immediately solved this issue. ⭐
Hi All, @clarab
We are using Alteryx Designer version 2020.4 in one of our Azure servers for development which has Microsoft Access database engine 2010.
Since Microsoft has stopped supporting the 2010 version and below, we are requested by our infra team to upgrade the database engine to Microsoft Access database engine 2016 or 2019.
Based on the information that other users have provided in this post, Microsoft Access database engine version 2010 is mandatory to read Microsoft Excel Binary (.xlsb) files as input.
Hence, would like to know if there are any impacts on the existing workflows or features in Alteryx due to this engine update.?
Appreciate your help and support in advance.
@Mahadeva For 2020.4, we only support MS Access Engine 2010 (32-bit). If you replace this with version 2016, you will likely be unable to use Excel Binary in Designer anymore.
@Mahadeva
As noted in my comment, you can use both the 32-bit 2010 and a 64-bit 2016. Using only 2016 will limit the capabilities of Designer.
Would like know if Alteryx 2021.3 support Microsoft Access Database Engine 2016 version. If so, is Excel Binary option enabled to read .xlsb files by default.
Due to security concerns, we cannot have Microsoft Access Database Engine 2010 version in our systems.
Appreciate your quick response.
@Mahadeva
Empirically, 2016 does not work. 2013 does if you are running 2021.2 or later. I think 2013 works whether you use the 32-bit or the 64-bit, but I have not explicitly tested that.
@lepome Thank you Lisa. Appreciate your quick reply.