I needed to import multiple Excel files into AX; all of them had a very similar format with the same columns. Python to the rescue. Ever since Build 2018 I’ve been using Visual Studio Code and enjoyed every moment of it, as I build Python scripts to assist me with anything I can think of. I highly suggest that tool, and the Cobalt2 theme, for increased productivity and debugging-
Blog Syndicated with Dag Calafell, III’s Permission Data Migration: Combining 105 Excel Files in 3 Minutes