News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... AX2012 Entity Export

Finance | Project Operations, Human Resources, ...

Answered

AX2012 Entity Export

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi,

I have a request to export the data for Vendor Entity in AX2012, and that would be easily done by the data import/export framework, but the entity has more than 255 fields or as we can say parameters, and that looks to be the limit when exporting to Excel since Excel can not have more than 255 columns.

So, my next idea was to export to CSV and then convert it to an Excel file but, that also is not working in my case because that data is not good and I can not find the right separator to separate the parameters.

Does anyone else face this problem, and maybe come with some solution?

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

André Arnaud de Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

RE: AX2012 Entity Export

Hi SIwannaS,

Excel 64-bit for sure doesn't have a limitation of of 255 columns, Do you need all the fields? You can also change the mapping and exclude fields which are not having values in all records.

Possibly, you can also try an xml format.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans