When 365 Automation manager is set up for Access, we have to manually create the ODBC to connect. This can sometimes be misconfigured to use the same as Access (SQL SERVER NATIVE Client 11.0) when it should be using SQL SERVER.
This causes import issues, such as invalid comparison between VARCHAR and TEXT in import item Stock Item UDF, as an example.