By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,225 Members | 1,434 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,225 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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.
Nov 13 '05 #3

P: n/a
Great articles. Thanks!

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.