This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am wondering if it is possible to connect to an access database and run update queries in an Alteryx workflow. I would imagine I will need to use the In-Database toolset, but I cannot figure out how to do this exactly. Thank you!
Or, you could build the logic of your queries into your workflow so that you don't have to switch over to access at all. For example, join your new data with the table you want to update in Alteryx, filter to only keep updated / unchanged items, then use the "Output" or "Write Data In-DB" tools to write over your table.