Skip to main content

Posts

Showing posts with the label excel spreadsheets

Step by step to Export table template in axapta using Excel Template Wizard MSDAX

If  You need to import any table data through template then you need to export template then fill the data then you need to import that template. To Get template of particular table  you can follow steps below.. 1. Click Navigation Pane node: Administration -> Periodic -> Data export/import -> Excel spreadsheets -> Template Wizard. Form name: Microsoft Office Excel Template Wizard Fig 1. 2. Click the Next > button. 3. Switch to the Open workbook tab on the Microsoft Office Excel Template Wizard form. Fig2 4. Change File name from '' to ' E:\test\doc\filename.xls'. 5. Click the Next > button. 6. Switch to the Select tables tab on the Microsoft Office Excel Template Wizard form. Fig3 7. Click the > button. 8. Click the Next > button. 9. Switch to the Generate field list tab on the Microsoft Office Excel Template Wizard form. Fig4 10. Click the Next > button. 1

Menu path to export table data in Excel Templates in MSD axapta

 This is  a menu path to export table data in Excel Templates. You can keep that data as table backup for security purpose. Administration -> Periodic -> Data Export/Import -> Excel SpreadSheets -> Template Wizard If you want to import that data  again in axapta then you can import same temple using following menu path. Administration -> Periodic -> Data Export/Import ->Import Excel Template.