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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,302 Most Valuable Professional
nmaenpaa 101,156