How to Connect ExcelReportLink to MYOB AccountRight 19

Overview

You can connect ExcelReportLink to your MYOB AccountRight Classic data file.

Connecting ExcelReportLink to MYOB AccountRight or prior

Data File Setup dialogue for MYOB AccountRight or Lower

To connect ExcelReportLink with MYOB AccountRight v19 or lower, follow these steps. You will need to have the MYOB ODBC driver installed before hand. Note that these instructions do not show you how get to the Data File Setup dialogue.

Go to the Data File Setup dialogue. See Changing how ExcelReportLink connects to your data file for more information;

1. Enter Company Name;
2. At Data File Type select MYOB AccountRight or prior;
3. Click the first Browse button to browse to your data file; It should have the file extension .myo
4. Enter the User Name and Password to connect to your data file;
5. Choose the Network Protocol. We do recommend you leave it with the default of TCPIP;
6. Leave the ODBC Driver as (Auto Detect) unless you experience issues with ExcelReportLink detecting the correct ODBC driver for your data file;
7. Leave the MYOB EXE Path blank;
8. Click OK to close the Data File Setup dialogue;
9. Click Close to close the Manage Data Files dialogue;
10. Run your first Get Data.

Notes

• We recommend you use the Administrator user when connecting to your MYOB data file to ensure ExcelReportLink has access to all data required to run your reports.

Related Topics

• Installing the MYOB ODBC driver
• Changing how ExcelReportLink connects to your data file