Output To Excel

ashiques

Hi

Can anyone tell me that how many fields can be goes in to excel by ALteryx output.
Like i have 570 field but my Module doesnt create the Excel file it have an error. "Error creating table "Sheet1": Microsoft Office Access Database Engine: Too many fields defined.3190 = -68092944"

Thanks in Advance

ChadM

Hi Ashique, the current Microsoft driver that Alteryx uses has a limit of 255 fields for input and output.  

The good news is that the 9.5 release contains a native Alteryx driver for reading in and writing to newer Excel (.xlsx) files, and we will not have the Microsoft driver limitations, so in the 9.5 release and up you will be able to write out your 570 fields.