How to speed up Importing of Excel XML Mapped tables
Posted on 2011-05-04
I have about 6 or 7 excel tables (list objects) mapped to xml files. These tables contain large amounts of data, some of them 4,000 rows or more. I use VBA to export and import these xml maps as follows:
ThisWorkbook.XmlMaps("InputTable_Map").Import (currClient.Path & "\input1.xml")
ActiveWorkbook.SaveAsXMLData currClient.Path & "\input1.xml", ActiveWorkbook.XmlMaps("InputTable_Map")
The export works very fast and there is no problem. The import though takes very long and could be up to a minute or so. I
The use of listobjects was chosen beacuase of the ability to add and delete rows in vba with minimal effort. Is there a faster option than what I'm currently using for saving and retrieving xml data?