• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Exporting and Importing Data... > Applying Custom XSL Transforms to XM...

Applying Custom XSL Transforms to XML Data

ReportML and the .xsl files it generates handle the most common use of XSLT—generating Web pages from your Access data. As mentioned earlier in the chapter, XSLT also can transform one class of XML documents to another. For example, you can apply XSLT to transform an XML data document to the format required by the Office Web Components (OWC) 11 Spreadsheet control.

Access doesn’t include in the Export XML dialog the capability to specify a custom .xsl file to process exported XML documents. By adding a small amount of VBA code to your Access application, however, you can apply a transform when importing or exporting XML documents. Access 2003’s Application.ExportXML and Application.ImportXML methods handle export/import operations, and the new Application.TransformXML method applies a custom transform.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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