Dynamic Input with Access Database - How to Chose the Table?

[Deliverance]

Hi all, I'm trying to use the Dynamic Input tool for an Access db but I'm not sure how to indicate the table name similar to how you'd add a sheet name if inputting from excel. Is there a way to do this for an Access db? I'm getting the same error as if you didn't indicate a sheet name when using excel: "No table chosen; Please select a Table from data source.

[MattBSlalom · Accepted solution]

An Access table uses the same format as an Excel sheet.  The format is <FilePath>|||<TableName>

For example:

C:\TEMP\Database1.mdb|||Table1

[apathetichell]

I think for .accdb files you need to follow these instructions to get your system objects/a.k.a. list of tables to be visible:

https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-list-all-tables-in-database-using-an...

then you need to have your batch macro read in each table:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Import-multiple-tables-from-Access-dat...