web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Import contents of a ....

Microsoft Dynamics AX (Archived)

Import contents of a .xlsx excel file and insert it in to LedgerJournalTrans table

(0) Share

Report

Report

Posted on by Community Member

Hi please anyone can send correct link of inserting the data from an excel file with extension .xlsx and insert that in to journal table LedgerJournalTrans Table in AX 2012 R3 using x++ code. We 4 people are struggling since last 1 week. Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Suggested answer

Community Member on at

Like (0)

Report

The SysExcel classes should work:

http://krishhdax.blogspot.de/2012/01/imports-data-from-excel-in-ax2012-using.html

https://chaituax.wordpress.com/2013/03/06/excel-file-import-using-x-code/

As far as I can recall this does not work for batch processing. In case you want to do batch processing you probably have to use .net

Was this reply helpful? Yes No
Verified answer

Umesh Pandit 9,315 User Group Leader on at

Like (0)

Report

Hi Mahesh,

Check this link:

axpedia.blogspot.in/.../import-from-excel-file-using-x-in-ax.html

axapta-rblearnt.blogspot.in/.../ax2012-read-and-import-excel-file-using.html

msdax.wordpress.com/.../how-to-add-formula-to-excel-column-while-data-export-from-dynamics-ax

stackoverflow.com/.../fast-access-to-excel-data-in-x

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

HI Mahesh, previous your import legerjournals from excel you imported data successfully can you please send that code

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans