Alison Balter's Mastering Access 2002 Enterprise Development

Exporting Gotchas

A few gotchas exist in the export process. First, the Access-generated XML file is not set up to automatically utilize the XSL document. One alternative is to use the HTML file generated during the export process. The HTML file uses scripting to combine the XML and XSL files. The other alternative is to modify the XML file and instruct it to use the appropriate XSL file. The modified XML file looks like this:

 <?xml version="1.0" encoding="UTF-8" ?> <?xml-stylesheet type="text/xsl" href="Shippers.xsl"?> <dataroot xmlns:od="urn:schemas-microsoft-com:officedata"> <Shippers> <ShipperID>1</ShipperID> <CompanyName>Speedy Express</CompanyName> <Phone>[phone]</Phone> </Shippers> <Shippers> <ShipperID>2</ShipperID> <CompanyName>United ...