Error Importing multiple Microsoft Access tables using the dynamic import tool

jlett

Hello - I have been struggling trying to create a workflow that can import multiple tables from an access database.  I got it to work fine with excel files (same data i loaded into the access database) but I need to source access to solve data integrity issues.  If I have the action set to "change entire file path" error is that i need to choose a table.  If the action is set to "change file/table name" the error is that it can't find the database.  Any help would be appreciated.  

I'm running 2018.3 on desktop.  I attached the workflow and data samples below.

Thanks,

Jim

Workflow Dynamic Input Access.yxmc

NicoleJohnson

Hello!

Couple suggestions here:

1. Make sure that you have the necessary Access driver - see article here for instructions on where to download the driver. This will allow Alteryx to connect to Access databases (which I'm guessing is the problem). 

2. If you go the "change file/table name" route, you should just be able to provide a list of tables, connect to the actual Access database as your initial input template configuration in your Dynamic Input tool (i.e. don't connect to Excel first if you're planning on connecting to Access for your dynamic input data), and then select the field containing the list of table names as your field to "change file/table name"... If you go the "change entire file path" route, you'll need to create a list of the full file path for each table name, which would include the file location as well as the table name, separated by ||| (three pipe characters). Example: "C:\Desktop\Folder Location\Access Database Name.accdb|||Table 1", "C:\Desktop\Folder Location\Access Database Name.accdb|||Table 2", etc.

If you validate that you have the Access driver and then follow the naming conventions for feeding your data into the Dynamic Input tool, I think this will solve your input issue! Please let us know if you run into additional issues, however... 

Cheers!

NJ