Click to See Complete Forum and Search --> : Inserting an XML document into Access
rustydatsun
Jan 16th, 2001, 10:29 AM
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
Jan 16th, 2001, 10:31 PM
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
Jan 18th, 2001, 07:35 AM
You would have thought so, but it's not happening as it should...
Thanks for the code snippet, I'll give it a go.
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.