Paste Append in Access Using Alteryx

[Cferrer6]

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

[BrandonB · Accepted solution]

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:

[Cferrer6]

Thank you! My Alteryx doesn't have "access 2007-2016" as an option. I am using 2020.4. Do you think thats why?

[BrandonB · Accepted solution]

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 

[Cferrer6]

It all worked! Thank you sooooooo mcuh 

[Hreimer22]

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?

[BrandonB]

@Hreimer22 you may need to close/reopen Alteryx or even restart your computer for the changes to take effect

[Hreimer22]

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?

[BrandonB]

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? 

[Hreimer22]

It has been installed and i now have the option for Access 2007-2016! Thank you for the help!