Axapta Data Import

From Axaptapedia

Jump to: navigation, search

I have large flat text files(tab delimited) exported out of our AS400 databases for importing into Axapta 3.0 SP4 system/MS SQL 2000.

These files can be quite large. Our contractor/consultant said that importing into Axapta with native importing tools will take a great amount of time.

What would be the preferred method of importing these files? I have imported test files using SQL server DTS Packages mapping columns to desired table fields.

The load did not take that long. Can this be done and still maintain REFID and DataAreaID index references? Should they default to something or will Axapta create these on Resync commands??

Thanks

MK

Try to write custom import via AsciiIO class.

Or generate RecId using SystemSequences table see http://www.eggheadcafe.com/forumarchives/axaptaprogramming/Aug2005/post23243136.asp MaxBelugin

When you have data that does take a long time to import or has errors you can't resolve, you can avoid the Excel import routines but it's tedious and not necessarily a Microsoft approved method. See 'Excel Import Workaround'.

JustGuessing

Retrieved from "http://www.axaptapedia.com/index.php?title=Axapta_Data_Import"
Personal tools