accdb (MS Access) connection through SharePoint connector

goutdelete

Hi,

We have a few monthly/ quarterly snapshot archive data within department saved in MS Access tables on Sharepoint (company policy unfortunately).

When we use data input tool everything is fine.  See sample below, a good 40K records shown.

Since the workflow is used among a few people and it is not ideal to have user change the path every single time.  We are hoping to use the Sharepoint connector directly.  However, since it's not YXDB, nor CSV or excel, the input tool would yield 0 record in the output.

Any one know how to set it correctly or is there another way to use data input tool so the user doesn't need to keep changing the path every time a different user runs the workflow?

Thanks!

Felipe_Ribeir0

Hi @goutdelete 

One way to do this is by using the batch input macro: The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten

This macro will allow you to pass the filepath dynamically

1) Use the GetEnvironmentVariable("USERNAME") function - it will get the username that is using the Alteryx machine - to build your filepath.

2) Properly configure the input tool inside of the macro to open accdb files

With this, the sharepoint filepath will work for each user without problems.

Batch Macro Workflow.yxzp