Coding XML import via VBA (1 Viewer)

ions

Access User
Local time
Today, 08:28
Joined
May 23, 2004
Messages
785
Dear Access Expert.

I want to automate the xml import of an xml file residing on

http://192.168.100.60/index.xml.

I am looking for a straight XML import... using VBA code

Do you forsee anyproblems with the the file being on a local networked machine?

Code Snippets would be much appreciated.

Thanks.
 

KernelK

Registered User.
Local time
Today, 11:28
Joined
Oct 3, 2006
Messages
173
I haven't done much with XML in a while. Had a discussion regarding parsing/importing of XML files a ways back though.

Check out this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=116258

Read through that and see if it answers any of your questions....

Also, it should be no problem for the xml document to reside on the local network. As long as the machine running the import has access to the file, everything will be fine.
 

ac001

New member
Local time
Today, 08:28
Joined
Jun 8, 2009
Messages
1
Here is the code to import xml to Access:

Dim appAccess As Object
Set appAccess = CreateObject("Access.Application")
appAccess.OpenCurrentDatabase ("C:\test.mdb")
appAccess.ImportXML "http://192.168.100.60/index.xml"
appAccess.CloseCurrentDatabase
appAccess.Quit acExit
Set appAccess = Nothing
 

Users who are viewing this thread

Top Bottom