web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Link to insert into database from excel File

(0) ShareShare
ReportReport
Posted on by

Please show me the link to get the code for me to insert data into ax table but from excel file 

Thanks a lot.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mea_ Profile Picture
    60,286 on at
  • Suggested answer
    Community Member Profile Picture
    on at

    where I use this code.....

    in form method or ovveride the clicked button??

  • Suggested answer
    Chaitanya Golla Profile Picture
    17,225 on at

    Hi,

    Can you let us know what kind of data you are looking to import.As, you can use excel-addins that are available out of box for certain data imports.

    Refer below links:

    (Importing Data to AX 2012 Using Excel Add-ins)

    community.dynamics.com/.../importing-data-to-ax-2012-using-excel-add-ins

    (About importing data from Microsoft Excel [AX 2012])

    Importing Data to AX 2012 Using Excel Add-ins

    Also, you can use X++ code to import data. It depends on your business requirement, either you can write this code in the clicked method of a button on form (or) as a class method.

    Refer below link:

    (Import From Excel File Using X++ in AX 2012 - Replace productType table with your table)

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

    Apart from this, you can use DIXF.

    Refer:

    blogs.msdn.microsoft.com/.../dixf-importing-data-using-excel-and-odbc

  • Community Member Profile Picture
    on at

    I want to insert into table where the data from excel ....

    I can't use excel add-ins because I want to make match condition with the old data that insert before...

    can you tell me with the code?

    because I want to make condition where the data same, the data can't in.

    Thanks a lot.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hai Golla, I want to use code X++ in button method, but how to describe the name ...because I got error.

    3782.test.jpg

  • Suggested answer
    Rudi Hansen Profile Picture
    4,079 on at

    The profile of your method is wrong, it should be like this.

    void clicked()


  • Community Member Profile Picture
    on at

    I don't understand

    4186.test1.jpg

  • Verified answer
    Rudi Hansen Profile Picture
    4,079 on at

    Remove the "static void ProductType(Args _args)" line

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans