Add data to multiple different Access database Output Files using filter

thelastmurphy

Hello community,

I am using Alteryx to edit data similar to the data attached. I have multiple Access databases in a file that need certain information from "Data-Example" added to them based on a condition. For example, my file "NY Accounts.accdb" need to have all fields with State=NY added in a separate tab, and if state = "GA" then the data would be added to the "GA Accounts.accdb" file.

Thanks for any help!

Data-Example.xlsx

Robin_McIntosh

Are you running into specific errors doing so?  Or just need guidance?

If you absolutely have to use .accdb, then take a look at this post if you are running into errors as you may need to install a specific driver.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Paste-Append-in-Access-Using-Alteryx/td-p/789823

If you can use .mdb instead, then here's an example on outputting.  You list your table name (new or existing) just like you would with Excel outputs.  Then make sure you select the appropriate Output Options to append, overwrite, etc.