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

[Cferrer6]

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?

[BrandonB]

@Cferrer6 It may be related to this response: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Enable-Microsoft-Excel-Binar... 

Otherwise, maybe you uninstalled something that you needed? 

[JayDeeB]

Thx