Forum Discussion

Justin_Sp's avatar
Justin_Sp
Contributing Cover User
6 years ago

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

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's avatar
    Steven_M
    Former Staff
    6 years ago

    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's avatar
    Mike_James
    Ultimate Cover User
    6 years ago

    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.

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.