Data Import Export tips through template in MSD axapta

If you are importing data for any single table through template then these tips can help you.

1. If you want to update only 4 columns data but table has more number of columns then you need to extract only 4 columns template with compulsory fields of tables.

2. If Master table already containing data and you want to retain other columns data then you need to select import new and update existing option from import dialog.

3. You should take backup of table data for safety purpose by exporting excel template with data.

4. Do not use clear table before import option its dangerous and it will delete previous data and will import template data.