Exporting forms from Access as XML files

[LeLe]

I am trying to create an XML file with schema for our Company's Order form.
The form is based on two tables: the order header and the order line items.
The XML dialog export box gives me a button called "more data" After I
click it I can click on both of the above tables that underlie my form;
however, after I complete the export, the line item table info is missing.
Why is the option there to export tables related to subforms there if it does
not appear to work? What am I missing? Obviously, I don't know much about
XML, and am hoping Access 07 will do the all the work of creating an XML
schema file for me.

Any insights are greatly appreciated.

 

[James A. Fortune]

I am trying to create an XML file with schema for our Company's Order form.
The form is based on two tables: the order header and the order line items.
The XML dialog export box gives me a button called "more data" After I
click it I can click on both of the above tables that underlie my form;
however, after I complete the export, the line item table info is missing.
Why is the option there to export tables related to subforms there if it does
not appear to work? What am I missing? Obviously, I don't know much about
XML, and am hoping Access 07 will do the all the work of creating an XML
schema file for me.

Any insights are greatly appreciated.

Microsoft has made a lot of information about XML freely available.
Perhaps start here:

A quick guide to XML Schema

http://msdn.microsoft.com/en-us/library/bb986126.aspx

In my C# class, using a WinForm with XML for data storage was listed as
one of the options for an assignment so I looked at the following this
past weekend:

Relational Data in XML Schemas

http://msdn.microsoft.com/en-us/library/53ef8za1(VS.71).aspx

Perhaps some of the nearby topics will provide some additional insight.

For the nuts and bolts, maybe:

How to: Export Data, Schema, and Related Tables to XML

http://msdn.microsoft.com/en-us/library/bb258193.aspx

which is part of the Access 2007 Developer Reference.

James A. Fortune
(e-mail address removed)

 

[LeLe]

Thanks. The links looks helpful

Microsoft has made a lot of information about XML freely available.
Perhaps start here:

A quick guide to XML Schema

http://msdn.microsoft.com/en-us/library/bb986126.aspx

In my C# class, using a WinForm with XML for data storage was listed as
one of the options for an assignment so I looked at the following this
past weekend:

Relational Data in XML Schemas

http://msdn.microsoft.com/en-us/library/53ef8za1(VS.71).aspx

Perhaps some of the nearby topics will provide some additional insight.

For the nuts and bolts, maybe:

How to: Export Data, Schema, and Related Tables to XML

http://msdn.microsoft.com/en-us/library/bb258193.aspx

which is part of the Access 2007 Developer Reference.

James A. Fortune
(e-mail address removed)