Hello Antony,
There are some old method to export data from NAV /BC
Goto Config. Package Card
Create New Card with table 1249

Goto Lines Part "Excel" Export Data in Excel
Sumit nandha
Please Verify the Answer to help Community members, if it was useful to you.