Alteryx read Microsoft Access Module query (sql)

Question

Hi,

Anyone has experience on how to read .accdb file module and sql in alteryx. I want to achieve the effect that able to use alteryx to call the access file to run access modules and macros( just like call API)

I only know how to read and output table from access. Pls help and share how to achieve this effect.

stevemarkovick · Answer

I’ve dealt with this before, and the tricky part is that Alteryx can’t directly interpret module-based queries from Access because they aren’t stored like normal saved queries. They’re more like VBA functions with embedded SQL. Extracting the SQL manually or rewriting it as a standard stored query inside Access usually solves it, and after that Alteryx reads it without any issues.

jrlindem · Answer

@alteryxbbb In researching a bit, I found a few articles that might help. Getting MS Access tables into Alteryx isn't that difficult, but reading the SQL directly may not be easily achievable. Take a look at some of these resources, and I hope it helps you along your way: Solved: Dynamic Input with Access Database - How to Chose ... - Alteryx Community Import MS Access Database file (.accdb) - Alteryx Community Microsoft Access - Alteryx Driver The most helpful tidbit was this piece: An Access table uses the same format as an Excel sheet. The format is ||| This, of course, is not reading the SQL, but may present a workable option for you to proceed in your work. Cheers, -Jay

alteryxbbb · Answer

Or if anyone could hint about how to read data from Access Query result thx