Inserting an XML document into Access

What I'm trying to do now, is to insert an XML document stored on my hard disk, into an Access database field.

I know how to do the database stuff, but I'm not sure how I open the file or create a reference to the file beforehand.

Any ideas guys ???

Well, if you know how to do the database stuff, then you just have to read the XML text, right?

Code:

---

    'Uses MSXML library
    Dim objDOM As DOMDocument
    Set objDOM = New DOMDocument
   
    objDOM.Load ("D:\myfile.xml")  'load the XML file
   
    MsgBox objDOM.xml  'we have XML!  Put this in your DB

---

You would have thought so, but it's not happening as it should...

Thanks for the code snippet, I'll give it a go.