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 ???
Printable View
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.