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.c om/print/microsoft-developers-1>

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

<http://www.microsoft.c om/downloads/details.aspx?Fa milyId=4922060F-002A-4F5B-AF74-978F2CD6C798&di splaylang=en>

<http://www.officezealo t.com/Upload/Gunderloy_WebSe rvice_Article/Gunderloy_Webse rvice.aspx>

bc******@bmghom es.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******@bmghom es.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.XMLHT TP to request the .xml file from a remote web server.

[bcanavan]

Great articles. Thanks!