Tutorial: Import data from MYOB into Excel. Part 2. By David Carter.

In the first tutorial we imported data from MYOB using Excel’s Import External Data command. We also added a couple of calculated fields, Amount and NGrp (Nominal Group).

However, if we want to create reports there’s still a lot of data missing. MYOB has lost the line description. And while we have code numbers for the nominal account and nominal group, we really need their names as well.

The lack of line description is a design fault within MYOB and we can’t retrieve it.

Continued...