Hi,
I want to inquire if i can use alteryx to feed in multiple reports and then paste append them into an access database. Is that possible? How could i have the output tool take the files and paste append to a table in alteryx
All that you have to do is configure your Output Data tool to append to the file. If you have multiple files that you are stacking prior to loading them into the Access Database you can use a Union tool to stack them all first and then use the Output Data tool to write them:
Alteryx comes with the mdb driver standard, but if you want to use Microsoft Access accdb files you need to download and install the Microsoft Access driver (it is free, don't worry!):
https://help.alteryx.com/20212/designer/data-sources
Link to download: https://www.microsoft.com/en-us/download/details.aspx?id=39358
Thank you! My Alteryx doesn't have "access 2007-2016" as an option. I am using 2020.4. Do you think thats why?
It all worked! Thank you sooooooo mcuh
Hello Brandon, I tried following this and once I got to this step I was able to download and install the Access Driver. However, the option for Access 2007-2016 still is not appearing. Are there any further steps I need to be taking or considerations that need to be made in order for this solution to fully work?
@Hreimer22 you may need to close/reopen Alteryx or even restart your computer for the changes to take effect
I have done both of those actions multiple times, and still nothing. I am running alteryx version 2020.1 x64. Does that have anything to do with the issues I am seeing?
Ah, you need the Microsoft Access Driver 2010, not the 2013/2016: https://www.microsoft.com/en-us/download/details.aspx?id=10910
Can you try this one?
It has been installed and i now have the option for Access 2007-2016! Thank you for the help!
Hi Brandon,
This worked for us but now we are not able to open access. Any ideas? i think the driver reset the access to mdb instead of accdb. Any ideas how to change it back so Access opens?
@Cferrer6 It may be related to this response: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Enable-Microsoft-Excel-Binary-Excel-Legacy-Access-accdb/tac-p/527989/highlight/true#M5164
Otherwise, maybe you uninstalled something that you needed?
Thx
