Alteryx read Microsoft Access Module query (sql)

[alteryxbbb]

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.

[alteryxbbb]

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

[jrlindem]

@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 <FilePath>|||<TableName>

This, of course, is not reading the SQL, but may present a workable option for you to proceed in your work.

Cheers, -Jay

[stevemarkovick]

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.