Zoho Tables with periods in field labels prevent table Access.

[pdi2022]

The Zoho CRM Lead module has a system field name [No. of Employees]. The initial linking of the MS Access Data using the the DevArts ODBC connection to the ZOHO Lead table fails because of the period. The label "No. of Employees" is designated invalid. This is observed for Unicode or ANSI encoding string type configurations.

I asked ZOHO about this, but expect no change, This field is a system field. I cannot bracket the field label because it is in accessible. Access to other ZOHO tables like the contact table works fine so I know its not in the communication. I believe the parser does not properly escape the field labels and halts the connection.

Unfortunately all the action is in the LEAD table. This is where I need the ODBC access to optimize the data, manage marketing list, and update tracking information from other sources. Running version 2.4.1. The error has been validated by DevArts support but so far not corrective versions offered.