Highlight the data file and then click "Import" to map the data directly to the spreadsheet under the table information, recreating the XML table within your Excel spreadsheet. Advertisement ...

The XML_vba_Excel.txt file is an implementation of database parsing in Excel using VBA. The Microsoft XML library, v 6.0, must be patched in Visual Basic for the macro to work correctly.