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.