topic Re: Microsoft Excel Legacy Output in Gallery in Alteryx Server Discussions

Microsoft Excel Legacy Output in Gallery

ghiggins — Mon, 10 Feb 2020 13:29:42 GMT

Per attached, I am exporting using an output tool with file format "Microsoft Excel Legacy" and output option set to "Delete Data & Append". I did this to keep excel format and also get rid of the old data present. This works until I try to schedule it in the gallery. The error attached shows, "Error opening connect string: Can't create Data Source Object (Tool Id: 209)". Could anyone help me on why this isn't working? Can the gallery not output to legacy files? If so is there any way to output multiple sheets to a template and keep the excel format? Output gets run weekly so a blank excel template wouldn't really work.

Thanks!

Re: Microsoft Excel Legacy Output in Gallery

joshuaburkhow — Mon, 10 Feb 2020 13:55:10 GMT

Hi @ghiggins

My guess is you need to driver installed on the server. You can read about that here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Output-legacy-Excel-files/td-p/8819

Hope this helps!

Joshua

Re: Microsoft Excel Legacy Output in Gallery

ghiggins — Mon, 10 Feb 2020 19:58:39 GMT

Thank you for the response! @joshuaburkhow

I tried this; however, I got the same error.

Re: Microsoft Excel Legacy Output in Gallery

ghiggins — Mon, 10 Feb 2020 20:01:42 GMT

Should be noted that the workflow only errors when ran from the gallery. There are no issues when run from my computer. @joshuaburkhow

Re: Microsoft Excel Legacy Output in Gallery

LisaL — Wed, 15 Apr 2020 17:49:20 GMT

@ghiggins

Would you please investigate which version of the Microsoft Access Database Redistributable you have installed on the server. In my experience, it only works with the 2010 32-bit version. If you find something different, please reply back.