Inserting an XML document into Access

[rustydatsun]

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 ???

[Clunietp]

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

    '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

[rustydatsun]

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

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