This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I think this error is the result of the driver not recognizing the feild types of your dataset properly. I would create a "dummy" row of data that has no nulls, and a representative data entry for each field. Likewise, if you are outputting to Access .accdb, make sure the first row doesn't contain any null entries.
So the process I took was to check the drivers were up to date, dowloading the lastest ones:
https://help.alteryx.com/9.5/DatabaseSupport.htm and it turns out I was also using an older version of the accesss database from which the data was being created, so again I renew this. Finally I connected to ACCDB in the input tool and solved!