Re: Transforming MS Access XML

Hi Antonio,

As a word of warning I have had troubles exporting XML from Access.
This was an older version then the current one (I was using Access XP
and the newest is Access 2003).  Elements were missing that should
have occurred as far as I can tell.  I have not found (and didn't
really look) for anyone else having similar problems, so it just may
be something in my setup.  I do recall one person with a slightly
similar problem creating an Access macro that outputted an XML file.

I did try using Excel and something similar to what you describe below
with two stylesheets, one stripped namespaces and the other making
conversions to a simpler xml application, which worked pretty well.

Jon Gorman

On Tue, 21 Dec 2004 17:32:57 +0000, Antsnio Mota <xptm@xxxxxxx> wrote:
> I just receive a Access XML output to integrate with one of my demo apps,
and
> i'll transform it to some simpler format of XML.
>
> Altought it seems not too dificult to do, using a modified identity
template
> using local names to get rid of namespaces (like the example of Michael Kay
> earlier today - great list this one is, that antecipates my needs by 12
> hours!!!) and another identity template to transform to my xml structure, i
> wonder if someone has allready done something like this.
>
> Just to check if there are some peculiarities that i'm not looking at right
> now...
>
> O SAPO ja esta livre de vmrus com a Panda Software, fique vocj tambim!
> Clique em: http://antivirus.sapo.pt