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 · Accepted solution]

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. 

[drahn]

Chad,

I seem to be getting this error when my output only consists of 6 fields. I have two string fields, and 5 numeric fields being output. There are only about 30 rows of data as well - a very small output. Is there anything else that would commonly throw this error?

Error: Tool #522: Error creating table "Users": Microsoft Access Database Engine: Too many fields defined.\3190 = -68092944
CREATE TABLE `Users` (`WhseID` varchar(6),`First_UserId` ntext,`2015_12_07` float,`2015_12_08` float,`2015_12_09` float,`2015_12_10` float,`2015_12_11` float,`2015_12_13` float)

Thanks for any thoughts you have!
Devin