Troubleshooting the MYOB ODBC driver
Overview
In order for ExcelReportLink to connect to your MYOB data file correctly, the MYOB ODBC Driver must be installed and working correctly. This applies to MYOB AccountRight but does not apply to MYOB AccountRight Live.
In order for the MYOB ODBC Driver to function correctly, some things must be configured correctly on your machine. In most situations, users do not experience any problems. The purpose of this guide is to assist those who have problems.
Install the MYOB ODBC driver
The MYOB ODBC driver must be installed in order for third-party software to connect to your MYOB Classic data file. For more information, see Installing the MYOB ODBC driver.
Verify and Optimise your Data File
Most errors relating to the MYOB ODBC driver can be resolved by verifying and optimising your data file. For more information, see Verifying and Optimising your MYOB Data File.
Test the MYOB ODBC driver using the TestConnection tool from MYOB
MYOB provides a TestConnection utility that can be used to test and see if the MYOB ODBC driver is installed and running correctly. For more information, see Testing the MYOB ODBC driver using the TestConnection tool from MYOB.
Check File and Folder Access Requirements
The MYOB ODBC driver requires Read and Write access to specific folders in order to function properly. For more information, see Checking file and folder access requirements for the MYOB ODBC driver.