Paste Append in Access Using Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Database Connection
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you! My Alteryx doesn't have "access 2007-2016" as an option. I am using 2020.4. Do you think thats why?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It all worked! Thank you sooooooo mcuh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Hreimer22 you may need to close/reopen Alteryx or even restart your computer for the changes to take effect
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It has been installed and i now have the option for Access 2007-2016! Thank you for the help!
