Import XML into recordset *NOT PERSIST FORMAT*
Posted on 2004-08-11
I'm looking for some sample code that will allow me to convert an XML file into an ADO recordset. Excel seems to have functions built in that convert XML straight into a table format in exactly the style I need, but it seems clumsy to have to open the XML file in Excel, save that down and then open that as a recordset - surely there is an easier way?
PLEASE NOTE this XML file was not created using the XML Persist option from the Save method of ADO. It is just a bog standard XML file:
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
Can anyone help?
I'll need some sample code to get the points I'm afraid, pointing me in the right direction won't be enough. A complete answer will get a further 500 points in a separately posted question.