Error processing excel files dynamically

[Tahir89]

Hi All,

I'm trying to run the Dynamic Input tool to open the latest Excel and I keep getting this error:

Error: Dynamic Input (192): Error opening connect string: Microsoft Access Database Engine: External table is not in the expected format.\3274 = -328602519

The input file template is "Excel File Binary".

[afv2688]

Have you tried this:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Manage-Data-Connections-Alteryx-11-0/t...

Cheers

[Tahir89]

Hi so in this case I found that the latest file type had been changed to a CSV.

[afv2688]

In that case you have to change the template of the dynamic input to accept CSV instead of excels, otherwise it won't work.

I would recommend to first be sure the type of file you are gonna always get (since it changes if it is either a csv or an excel) and after configure your input for that type of file.

[afv2688 · Accepted solution]

Also, if you are never sure which type of file you are gonna get you could use something like this (for example):

[Tahir89]

Perfect! Cheers :)