Add Xml File As Data Source. Select the Data Source where the XML file resides. If youre using Excel 2016 or earlier click Data From Other Sources From XML Data Import.
To create an XML data source drag the XmlDataSource icon from the Data tab of the Toolbox onto the form select Configure Data Source from the controls smart tag menu and proceed from there. 6 minutes to read. Follow this article when you want to parse the XML files.
So basically you should use OLEDB as the data source then in the connection string type.
This article describes how to read and write an XML file as an Apache Spark data source. Click Add to add a new XML schema find your schemaxml file in the browser and click OK. So basically you should use OLEDB as the data source then in the connection string type. Using Composite would provide the most flexible option as it fully supports XML as data source.
