Can an Access 2002+ app "link" to local xml files?

[bcanavan]

If I push/pull an xml file from/to a client pc across the internet, can
Access link to it directly, or would I have to import the xml data to a
table?

If I have to import it, what features might Access have that would
allow me to automate the import?

Thanks,

Bob

[Ananda Sim]

Hi Bob,

You'd be interested articles about consuming an XML service via Office
XP SOAP Toolkit, ADO and XML persisted recordsets etc...

<http://www.sitepoint.com/print/microsoft-developers-1>

<http://www.perfectxml.com/articles/WebSvc/MSWebSvc.asp#8>

<http://www.microsoft.com/downloads/details.aspx?FamilyId=4922060F-002A-4F5B-AF74-978F2CD6C798&displaylang=en>

<http://www.officezealot.com/Upload/Gunderloy_WebService_Article/Gunderloy_Webservice.aspx>

bc******@bmghomes.com wrote:

If I push/pull an xml file from/to a client pc across the internet, can
Access link to it directly, or would I have to import the xml data to a
table?

If I have to import it, what features might Access have that would
allow me to automate the import?

Thanks,

Bob

[rkc]

bc******@bmghomes.com wrote:

If I push/pull an xml file from/to a client pc across the internet, can
Access link to it directly, or would I have to import the xml data to a
table?

Using Access 2002 (XP) I know:
You can use ADO to open a recordset from a local .xml file.
You can then use the recordset as the source for an uneditable Form.

I have done something similar to what you are contemplating using
Microsoft.XMLHTTP to request the .xml file from a remote web server.

[bcanavan]

Great articles. Thanks!