Austlink Help Centre


MYOB Exo Business Integration with Excel

I have created a video below on how to extract data from MYOB Exo Business to Excel.


There are two methods, a simple copy and paste method and a more complected direct SQL connection method


Extract Data from MYOB Exo Business - Simple Method


This first method is a simple copy and paste from any of the MYOB Exo Grids.

Just right click on the grid header and select "Copy to clipboard"




Now open Excel, right click on a cell and select to paste.

The contents of the MYOB Exo grid will now be available to you inside Excel





Extract Data from MYOB Exo Business - Advanced Method

Another way to extract data from MYOB Exo or indeed any other Microsoft SQL data source is to us the data connectivity features within Excel to create a direct connection to the Microsoft SQL database.


In Excel select the data tab and the "from Other Sources" button 



Select "From SQL Server"



Enter in your SQL server name and credentials



Select the database you are interested in extracting data from and also select the specific table name




Enter in a description for the data connection and then press "Finish"



Select the cell you want to import the data to and press OK




You will be asked for your password again. Enter it in and press OK




Your MYOB Exo data will be loaded into the spreadsheet



The good thing about this method is that to update the informtion all you need to do is right click on the table and select the "Refresh" option. Your data will now bring in the latest information from MYOB Exo




Here is a video showing you step by step through both processes:



This video is best seen on the full screen. Just click on the icon at the bottom right of the video (see image below).

To exit full screen just press escape 



Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


This entire document, including design, text, videos,graphics, and photographs are Copyright © 2014 Austlink Plus Pty Ltd, All Rights Reserved.
No part of this document may be reproduced in any way or by any means for commercial or any other purposes, without prior written permission of Austlink Plus Pty Ltd. Use of any data for the purpose of creating promotional materials or producing a printed or electronic catalog of any kind is expressly forbidden without prior written permission of Austlink Plus Pty Ltd.

Powered by Zendesk