• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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>(503) 555-9831</Phone>
  </Shippers>
 <Shippers>
  <ShipperID>2</ShipperID>
  <CompanyName>United Package</CompanyName>
  <Phone>(503) 555-3199</Phone>
  </Shippers>
 <Shippers>
  <ShipperID>3</ShipperID>
  <CompanyName>Federal Shipping</CompanyName>
  <Phone>(503) 555-9931</Phone>
  </Shippers>
  </dataroot>


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint