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.
Debating whether or not to upgrade to the latest version of Alteryx Designer?
Microsoft Access 2000-2003 does not access big integer
Integer — For integers that range from -32,768 to +32,767. Storage requirement is two bytes.
You can find MS documentation here : https://support.office.com/en-us/article/set-the-field-size-ba65e5a7-2e6f-4737-8e72-36b93f966a33
So when you use Alteryx with big integer (e.g Int64 ), it won't work the way you expected and the field will be converted into Double.So what I propose :
-a change in documentation about this behaviour-a warning message on the output box when you use Access and you have Int64
-ability to select Access 2016 in order to use Long integer formatBest regards,Simon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.