This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Office or the AccessDatabaseEngine.exe must be installed on the machine running Alteryx.
2. Do you have the right drivers?
You may need to install an additional driver to get the .exe listed above. Download the Microsoft Access Database Engine 2010 Redistributable, which will "install a set of components that can be used to facilitate transfer of data between 2010 Microsoft Office System files and non-Microsoft Office applications."
On some 64-bit Office environments, you may still have to use the 32-bit AccessDatabaseEngine.exe (The 64-bit may still work in these cases, but fail for date/time data types). It's not very clear why this happens, but this Microsoft article discusses some of the advantages/drawbacks of the respective Office bit versions: 64-bit editions of Office 2013.
3. Are you writing out more than 2 GB?
Access .accdb files have a number of limitations you should be aware of, but the big one is a 2 gigabyte size limit.
4. Does your first row of data contain NULLs?
If you're outputting, make sure each of your fields has a representative value in the first row. Sometimes having nulls in the first row will cause the Access drivers to have trouble determining what data type belongs there. Try adding a "dummy" row on top of your data with no nulls.
As always, don't hesitate to reach out to Customer Support if these steps fail to resolve your issue.