Sometimes it's needed to export a bunch of records to Excel to analyze a problem. If it's a small amount of data you can copy paste it directly from the table in Excel. But it happens a lot to me that I have to kill NAV after a couple of minutes because this approach takes too much time. Writing a data- or xmlport is then the only option.
Or....... let OMA do this for you!
Run the table from the Object Explorer and choose the format you want to export the data to.
Another little advantage of using this option is that it's much easier to choose the fields you want to export. If you run a table from the NAV Object Designer you will have to make a click for each field you want to hide.
Look at a demo on YouTube!