Data Migration: Combining 105 Excel Files in 3 Minutes
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
More About This Author
Array
Finance & Operations25 August 2021Opportunity in Analytics for Microsoft Dynamics 365
Finance & Operations12 July 2021Throttling on Dynamics 365 Finance & Operations (Supply Chain Management) Starting 10.0.19
Finance & Operations11 June 2021Remove $id from Custom Web Service JSON – Dynamics 365 F&O
Finance & Operations9 June 2021Link to an Azure Logic App Run
