Microsoft Access Queries in Alteryx

[qhawendhlovu]

Hello. Does anyone know if Alteryx can directly read and execute (on a data set) Microsoft Access queries or can we only use Alteryx tools (e.g., Formula and Summarize) to replicate what the Microsoft Access query/code is doing?

[danilang]

Hi @qhawendhlovu 

Alteryx cannot directly execute actions (macros, queries, data refreshes, etc) in any other application, without having some kind of external mechanism to execute the action on it's behalf.  For databases that mechanism is passing sql queries or calling stored procedures which are implemented in the Input and Output tools .  For Office apps it's VBS, PowerShell or some equivalent.  For these script type executions, you'll need to build a vbs or PS script and execute it using a Run Command tool.

Dan