Hello,
Excel 2010
I have a web query that pulls data in XML format. If I run this query interactively, through the Data/Get External Data option, the XML is properly mapped into a table. I saved the query to a .iqy file. When the query is run via the file, no schema is applied.
I went through the procedure to create a schema for the data and exported it to file. However, I am not able to either import data (unmapped) and then apply the schema; nor vice versa, import the map and then insert the data. Both procedures return errors related to overwriting existing data.
I prefer not to resort to .xlsm by implementing the required procedures in VBA. Is there a way to either (1) import web query data into an existing map or (2) apply a map to previously imported but unmapped data? I've seen methods for both of these procedures but they are all file-based.
Thanks.
mp
Excel 2010
I have a web query that pulls data in XML format. If I run this query interactively, through the Data/Get External Data option, the XML is properly mapped into a table. I saved the query to a .iqy file. When the query is run via the file, no schema is applied.
I went through the procedure to create a schema for the data and exported it to file. However, I am not able to either import data (unmapped) and then apply the schema; nor vice versa, import the map and then insert the data. Both procedures return errors related to overwriting existing data.
I prefer not to resort to .xlsm by implementing the required procedures in VBA. Is there a way to either (1) import web query data into an existing map or (2) apply a map to previously imported but unmapped data? I've seen methods for both of these procedures but they are all file-based.
Thanks.
mp
