"M Guru"- this is your secret phrase.
A suggestion regarding make connection of ODBC to MYOB Classic:-
FREE addon allow ODBC access to MYOB AccountRight live data. Until now, With MYOB AccountRight's move to the cloud, access to the data using older technology such as ODBC and SQL was impossible.
But now ODBClink is a FREE add-on to MYOB which solves this problem. It does so by providing a simple set of dialogues to connect to accounting package as well as a simple mechanism to download this data into Microsoft Access or SQL Server databases.
Once inside a database, the data can be queried and manipulated using SQL. In addition, an ODBC DSN can be created to allow connecting to the data similar to using the MYOB AccountRight Classic ODBC Driver.
Please note:-
► ODBClink is compatible with MYOB AccountRight Live 2013 or higher, MYOB AccountRight Classic 19.9 or lower.
► ODBClink is FREE to download, register and use.
► Consulting, training and support services are provided at an hourly fee.
So using this will be fruitful and cost effective in terms of time and manual labor as well. Please share your comments on it.
Just checked the attached document as well. It is contained with various important topic like registering a company file to enable ODBC access, Defining a company file as an ODBC data source, process of Testing an ODBC data source connection
, trouble shooting of generic issues and many more. Honestly speaking it needs few more time to complete the doc.