XML, DTD, how do you do this?

[Phil]

I need to create an XML output file from an Access 2000
database using a DTD file that I have been given.

Is there any way to do this?
As far as I am aware you export a query to an XML output
file and follow the screens instructions but there is
nowhere to associate the DTD file.

Also
The DTD file has joins to another table, How do you do
this?

Any help would be greatly appreciated.

Phil.

 

[John Nurick]

Hi Phil,

XML support was pretty basic in Access 2000. I'm not an expert in this
area, but I understand it you'd need to write your own code addressing
the DOM to do this kind of thing.

Access 2003 has much more XML capability and it would be worth
investigating that before you start planning the code.

 

[Guest]

Thanks for your reply John,
And sorry for sounding like an amature here, but, to do
what you explained, I guess I can do this in the in an
Access module by referencing the XML object and go from
there?
Then I should be able to point to my DTD file to get the
structure of the XML file to how it is needed.

-----Original Message-----
Hi Phil,

XML support was pretty basic in Access 2000. I'm not an expert in this
area, but I understand it you'd need to write your own code addressing
the DOM to do this kind of thing.

Access 2003 has much more XML capability and it would be worth
investigating that before you start planning the code.

I need to create an XML output file from an Access 2000
database using a DTD file that I have been given.

Is there any way to do this?
As far as I am aware you export a query to an XML output
file and follow the screens instructions but there is
nowhere to associate the DTD file.

Also
The DTD file has joins to another table, How do you do
this?

Any help would be greatly appreciated.

Phil.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[Guest]

Thanks for your reply John,

Do you happen to know of any sample code snippets that may
be around?
I am still having trouble XML output file to resemble the
DTD file I have.

Regards,
Phil.

-----Original Message-----
Hi Phil,

XML support was pretty basic in Access 2000. I'm not an expert in this
area, but I understand it you'd need to write your own code addressing
the DOM to do this kind of thing.

Access 2003 has much more XML capability and it would be worth
investigating that before you start planning the code.

I need to create an XML output file from an Access 2000
database using a DTD file that I have been given.

Is there any way to do this?
As far as I am aware you export a query to an XML output
file and follow the screens instructions but there is
nowhere to associate the DTD file.

Also
The DTD file has joins to another table, How do you do
this?

Any help would be greatly appreciated.

Phil.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

Hi Phil,

All I can suggest is what I'd do myself: (1) if possible, upgrade to
Access 2003l; (2) Technet, MSDN, Google and Google advanced groups
search.

Thanks for your reply John,

Do you happen to know of any sample code snippets that may
be around?
I am still having trouble XML output file to resemble the
DTD file I have.

Regards,
Phil.

-----Original Message-----
Hi Phil,

XML support was pretty basic in Access 2000. I'm not an expert in this
area, but I understand it you'd need to write your own code addressing
the DOM to do this kind of thing.

Access 2003 has much more XML capability and it would be worth
investigating that before you start planning the code.

I need to create an XML output file from an Access 2000
database using a DTD file that I have been given.

Is there any way to do this?
As far as I am aware you export a query to an XML output
file and follow the screens instructions but there is
nowhere to associate the DTD file.

Also
The DTD file has joins to another table, How do you do
this?

Any help would be greatly appreciated.

Phil.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.