community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Run Update Queries in Access through Alteryx workflow

Meteor

Hello,

 

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!

Meteoroid

Hello @bluebrent,

 

You might be able to use the "Run Command" tool in Alteryx to run a batch file which would open access, run the queries you need, then exit. More info here on creating the batch file:

https://stackoverflow.com/questions/15220462/batch-file-to-run-an-ms-access-query-and

 

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. 

 

Overwrite.PNG

 

 

Labels