MYOB

Module that can be import from MYOB System

Data Migration from MYOB	Module	Data Migration from MYOB	Module	Data Migration from MYOB	Module
Chart of Account	Yes	Customer Master	Yes	Supplier Master	Yes
Stock Master	Yes	Project Master	Yes	Area Master	Yes
Agent Master	Yes	Terms Master	Yes	Currency Master	Yes

Setting of MYOB Backup file

Here are the step-by-step guide how to do with MYOB database before import into SQL:-

1. Get the MYOB Backup file ( XXX_20160908.zip ) and place the backup file to the Desktop, example C:\Users\SQL\Desktop\MYOB.
2. Download 7 Zip to extract MYOB Backup file.
Download Path for 7 Zip : Window 32 Bits : http://www.sql.com.my/utility/7-zip.msi Window 64 Bits: http://www.sql.com.my/utility/7-zip-x64.msi

* Make sure install the right one or else you cannot find 7 zip to Extract.

3. Refer Image below on How to Extract MYOB Backup file.

• 3.1 Right click on MYOB Backup file.
• 3.2 Select "7-Zip"
• 3.3 Select "Extract Files"
• 3.4 Extracted file will show as another folder.

Import Data from MYOB

Import Account Master Data

1. Create New Database then Log On New Company with ADMIN User.

2. Once Log On, Go to File | Data Import |Select MYOB.

3. Click on the "Download button" to download a compulsory tool before import MYOB, then place the 'myData CLI' to C:\Users\SQL\Desktop\MYOB.

4. Click on the "Select File" button and look into C:\Users\SQL\Desktop\MYOB to select 'mydatacli.zip'.

5. Click "Select File" button then look into "C:\Users\SQL\Desktop\MYOB\TEST_20160908\DATAFILES\MYOB DATA CD\MYOB Data Backup" to select "Test 2015-2016v161.MYO" (MYOB Backup File)

Those highlighted in BOLD is based on own Company Name of MYOB Backup.



6. Refer step below to start import.