I've just been informed that an Access 2003 based system in use at one
of my customers now needs to send data in the form of an XML file to a
webservice. They told me it was simple - but I don't know anything
about it and a googling session yesterday made it look very
complicated.

So can anyone help with this question - I don't need anything fancy
and I haven't got the experience to work it all out for myself from
first principles (even though I know I should), I just want to send a
file occasionally. Is there a simple way to do this and if so can
anyone give me a link to follow?

Thanks
Dave

"Dave G @ K2" <DaveGriffiths70 (AT) gmail (DOT) com> wrote

1. Create a query to return the data formatted and sorted as required.
2. With the query selected in the db window, click File->Export...
3. In the Save As dialog, drop down the 'files of type' combo and select
XML.
4. In the dialog that pops up, select which files to generate.
5. Click OK.

Done.

Sorry - I should have made it much clearer. My client runs a large and
complex Access 2003 database on a LAN which I have written and
maintain and support. They also have a large and complex website which
I have absolutely no involvement with - it's not my thing

I regularly need to automatically send data of various types, files,
photos etc to the web server whenever certain events are triggered. I
do this a lot right now and the method I have used is to create an XML
file, or whatever is needed, and attach it to an email which is sent
to the web server where it is duly dealt with using perl and php I'm
told. I have found it to be very reliable since emails never fail to
get to the other end.

Unfortunately they now they have a new web programmer and he reckons
that's an old fashioned way to do things and insists that we should be
using webservices to send data from the Access database to their web
server for a new project we're working on.

So it's not the creation of the file that is the problem. It's the
fact that I don't know the first thing about webservices and how to
send the data, and I need to do this fairly quickly, and this is where
I'm seeking guidance

Thanks
Dave

"Dave G @ K2" <DaveGriffiths70 (AT) gmail (DOT) com> wrote in news:b28f44ac-c6ba-
4c86-aacb-ad033e700b7a (AT) n58g2000...oglegroups.com:

On a recent holiday I played bridge with a couple who said they played
"five card majors". I asked them to describe what they meant by "five
card majors".
Later one of the couple made a disparaging remark about my not knowing
what "five card majors" meant. Actually, I did know what "five card
majors" meant to me but I wanted to be sure what it meant to them.

Regardless, I would find a believable reason for asking the new web
programmer to describe more fully what he meant by "using webservices to
send data from the Access database to their web server.”
If he/she answered you could tell us and there might be more than one
person here who is actually doing that and could and would help.

Yhe web services add-in for access can be downloed here:

http://msdn2.microsoft.com/en-us/office/bb400914.aspx

You can most certainly use web services with access 2003.



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal (AT) msn (DOT) com