Error opening connect string: Can't create Data Source Object

[robertbrussell1]

Hello AltCommunity,

I have a system generated Excel file (.xlsx) that i'm having trouble connecting an Input Tool to.  Alteryx is not recognizing the Sheet Name.  I've found that if I configure the File Format to Microsoft Excel Legacy, it works!  However, when attempting to run on Alteryx Server I receive this error message: Error opening connect string: Can't create Data Source Object.

Has anyone run into this issue?  If so, how did you resolve it?

[TrevorS]

Hello @robertbrussell1 

Could you please include your workflow and a screenshot of the error message?

This will help the community to troubleshoot the issue you may be encountering better.

Thanks!

Trevor

[robertbrussell1 · Accepted solution]

My solution was to generate and use a .csv instead of the legacy excel file.