No there is no simple way, the shared table and database structure have complicated everything. The Excel add-in is an end-user interface but is not recommended for data migration, as a partner you need to create a migration strategy, this could be in-house scripts and templates, it could be a tool like Atlas or To-Increase Data Migration Studio, but you cannot assume it will be simple and there is no longer a viable tool out of the box in AX2012.
Lee looks like he may have got a solution for his initial question, but I have another (related) one…
My company has just upgraded from AX 2009 to 2012 and uses Atlas for data migration into Excel. Creating an export template hasn’t been an issue but the exceptionally slow speed of refreshing exported data in Atlas is now a major concern. Before investigating network & hardware capabilities and performance, can anyone else who’s experienced something similar (and who might have identified causes for the poor performance) please advise?
My understanding is that this has always been an issue with Atlas, and with the complications of AX2012 it has exacerbated the issue. However this is not from personal experience. Have you talked to Atlas?
It is almost impossible to upload data into AX using SQL. Better to use either Alpha or beta version of Data migration framework from MS. Beta version of this tool is available for download from http://informationsource.dynamics.com/.