Part III: More-Advanced Access Techniques
626
FIGURE 17.18
Advanced XML export options
The data contained in an XML file may be relational or hierarchical. For example, a single XML file
might contain information on both product categories and the products themselves. A schema file is
needed for complex XML to be understood by other applications. Access automatically produces a
schema file (.xsd extension) for data exported in XML format. Figure 17.19 shows the Schema
tab of the Export XML dialog box.
FIGURE 17.19
Exporting XML schema information
The XML schema file includes information such as the data type of each field and the source table’s
primary key and indexes.