XML and Access

3 4

Significant XML support has been added to Access, both in the core product and in data access pages. XML extends HTML to deal with structured data from many applications and allows the creation of custom data formats for special situations. Some of the new features are described briefly in this section.

XML Import/Export

You can create XML data or schema documents from Jet or SQL Server structures and data, or you can use XML data or schema documents to import (either programmatically or through the export user interface) data or structure into either SQL Server or Jet.

Import User Interface

The Import dialog box (choose File, Get External Data, Import) now provides an XML Documents selection, which allows you to import schema and data documents into either SQL Server or Jet. Figure 1-13 shows the XML Documents selection.

figure 1-13. you can import an xml document into either sql server or jet.

Figure 1-13. You can import an XML document into either SQL Server or Jet.

Export User Interface

The Access table/query/report/form export feature (choose File, Export with a table, query, report, or form selected) now includes an XML Documents Save As Type selection, as shown in Figure 1-14.

figure 1-14. you can export an access database object to an xml document.

Figure 1-14. You can export an Access database object to an XML document.

XSL Transformations and Presentations

With Extensible Stylesheet Language (XSL), you can create your own style sheets for formatting XML data. You can create your own XSL data transformations for changing the data document format, and you can also create your own presentation formats and add them to the drop-down lists within the Export and Import dialog boxes by adding a metaheader to your XSL document.



Microsoft Access Version 2002 Inside Out
Microsoft Access Version 2002 Inside Out (Inside Out (Microsoft))
ISBN: 0735612838
EAN: 2147483647
Year: 2005
Pages: 172
Authors: Helen Feddema

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net