Skip to main content

Posts

Showing posts with the label way to improve performance of Import data through Excel template in axapta

How to improve performance of Import data through Excel template in MSD axapta

There are two ways to improve performance of Import data through Excel template in axapta. Method one: You can Import the excel data into table in a dummy database of sql server or other dummy table in same database. Then you need to Create a odbc connection to the dummy database in the machine After that you need to Create a job in Axapta with odbc connectivity and pull the data by sql query. After reading the data then insert into respective tables of Axapta. You need to write database connectivity script. You can get that code on this blog too. Just use search box. Method two: Second method is you can use standard import functionality but  Don't use excel, you can use custom type importing option then convert your excel data into CSV format and define the table & columns and import the data.I am sure approx 20k records will be import few minutes.I hope This is the better way to import bulk records.