Forum Discussion
Refresh the XML Mapping of a Folder
Hello everyone,
Currently I have a mapped table where all my XML forms are gathered, however I would like Excel to automatically import this data to me without having to click on the "import" click.
Is it then possible to update an XML mapping without necessarily importing?
Thank you in advance for your feedback,
cordially
Remy DARQUES
7 Replies
- mlohaniCopper ContributorMaybe this can help you.
https://www.proworkflow.com/blog/2009/10/import-csv-xml-files-into-excel/
They have information on how to import XML and CSV files into excel. - NikolinoDEPlatinum ContributorImport XML Files into Excel
https://www.howtoexcel.org/power-query/import-xml-files/
Just a info to help 🙂- Remi131765Copper Contributor
NikolinoDEthank you for your answer.
However it seems to me that this import method via Power Query only allows you to select a single XML file while my objective would be to bring all my new XML files back to my table from an actualization.
- NikolinoDEPlatinum Contributor
For more information about issues, see Common issues with importing XML data at the end of this article.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)