community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Updated to 11.7 and now workflows writing to named ranges in .xls don't work

Asteroid

Wondering if anyone else has experienced this.  I updated this morning to 11.7 (finally) and immediately a workflow i had failed.  I looked into it and it was an older workflow that is writing data to a named range in an .xls.  The error provided is: 

Error opening connect string: Microsoft access database engine: external table is not in the expected format

 

I do not believe this is the same error as the windows update as when i uninstalled 11.7 and reinstalled 11.5, that workflow runs fine again.

Alteryx
Alteryx

Hi @Voska

 

Can you install these Microsoft drivers: http://www.microsoft.com/en-us/download/details.aspx?id=3 these have helped similar errors previously.

 

Best,

 

Jordan Barker

Solutions Consultant

 

 

Asteroid

Hello,

Sorry for the long delay.  I installed the drivers but am still getting the following error:

 

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

 

I can confirm that prior i rolled back to 11.5 and the workflow worked.  Just recently went back to 11.7 and again the workflow doesn't work.  What changed between 11.5 and 11.7 that broke writing to a named range in a .xls?

 

Thanks,

Highlighted
Meteoroid

Jordan,

 

Do you have and updated link to the drivers?  This one is bad.

 

-Dan

Atom

facing the Same problem; attached error file. Also, I have the following Alteryx verison:

2018.2.5.48994

 

 

Alteryx
Alteryx

@Romodh21 & @dmagnus2

 

You can find the new link here: https://www.microsoft.com/en-us/download/details.aspx?id=13255

 

Best,

 

Jordan

Labels