Access 97 and XML

[Jason K]

I am trying to work with a dynamically changing XML page.
I want to be able to work with this page in VBA script.
Does Access 97 have the capability to work with XML???
Any information provided would be greatly appreciated.

Thanks,
Jason Kelly

 

[Douglas J. Steele]

Not directly, but you should be able to add a reference to Microsoft XML and
use it programmatically.

Check http://msdn.microsoft.com/downloads/list/xmlgeneral.asp to download it
if you don't already have it.

 

[david epsom dot com dot au]

Or a reference to ADO and use the limited ADO XML
features.

(david)

 

[Rick Brandt]

Or a reference to ADO and use the limited ADO XML
features.

(david)

Can you do that in Access 97?

 

[david epsom dot com dot au]

Can you do that in Access 97?

You can if you have ADO installed.

(david)

 

[Joe Fallon]

I have done it in A97 and it is not trivial.
A2002 (and 2003) handle XML so well it would be far cheaper to upgrade than
to spend a weekend writing it yourself for 1 specific file type.