Hello - connecting to an SQL server (sitting on Azure) and wanting to extract an XML field, using VBA, and ultimately parse it. Having trouble even grabbing the field. The prior programmer used ADO, but I'm more comfortable with DAO. It seems the connection is working (using ADO, but again I may convert to DAO). I can see the name of the field being referred to for example, e.g., Recordset.fields.item(0).name. But getting the XML value is proving to not be easy. I get empty values even though the field is populated on the SQL server side.
Any sample coding to help here? MANY THANKS.
Any sample coding to help here? MANY THANKS.