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
Solved! Go to Solution.
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