Welcome to the Alteryx Knowledge Base

Microsoft Access Runtime/Database Engine is required for the following file formats:

• Microsoft Excel Binary (.xlsb)
• Microsoft Excel Legacy (.xlsx)
• Microsoft Access (.accdb) 

If you do not see these options in the In/Out tools, a separate installation is required from Microsoft. The driver does not come with our installation but from either Microsoft Office or a separate driver installation.

A full Microsoft Office or Access installation will have installed the necessary components on the machine. However, most organizations do not install all components.

Please follow the instructions in this article to download and install the required driver for these file formats.

• Alteryx Designer
  • All versions

1. Choose a driver version based on your version of Designer (64-bit):

• 2022.3_Patch_3+,  2023.1,  2023.2,  2024.1
  • Access 2016 Driver
  • Access 365 Driver 
• 2021.2+
  • Access 2013 Driver
• 2021.1 and prior
  • Access 2010 Driver (32-bit only)

2. Follow the instructions to download the installer.
3. Run the installer. The Microsoft Driver will appear in the ODBC Data Sources App > Drivers tab.
4. Restart Designer (or the Service if installing on Server)
5. After installation, you should be able to find the Excel Binary, Excel Legacy, and Microsoft Access (.accdb) options in the Input Data tool and the Output Data tool.

• Microsoft Access 2007, 2010, 2013, 2016, 2019, and 2021