MYOB2019.2 connection to Excel to extract data for reporting in excel (instead of MYOB v19.5 using ODBC)

[Justin_Sp]

I currently use ODBC link with MYOB Premier V19.15 to extract data into excel so that i can report in excel.

Within excel i go to Data tab / "From Other Sources" / "From Microsoft Query" / then choose a link I have created in ODBC to the MYOB ledger

Can anyone tell me how I can link in a similar way for excel to extract data from the new MYOB 2019.2? I've been told it does not work with the data source in ODBC named "MYOAU1001"

Does anyone know how to do this or can point me in the direction of someone who does?

Thanks

[Steven_M]

Hi @Justin_Sp 

Third-party software interaction with AccountRight 2019 is done through the AccountRight API. You can find out more information on the AccountRight API and getting starting using that via the MYOB Developer Centre

[Mike_James]

Hi @Justin_Sp , do you mean that you use the product called "ODBCLink" from Accounting Addons? If so, they make a version which works with the new AccountRight.