Error processing excel files dynamically

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".

Input

Accepted answers

afv2688

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

All comments

afv2688

Have you tried this:

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

Cheers

Tahir89

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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703