Microsoft Access 2010 Bible

(Rick Simeone) #1

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.
Free download pdf