When using the Open Database Connectivity (ODBC) in Excel to extract banking information of vendors (table: tVenDP) from sage data base, couple of fields spits out scrambled data (fields: sBankNo, sTransitNo, and sAccountNo).
We think it might be security reasons, but unsure how to allow permission to export data to Excel.
It would be great if we can get more information regarding why this is happening and how we can fix it.