Importing and Exporting XML Data

XML (Extensible Markup Language) is a universal language that enables you to move information across the Internet and programs where the data is stored independently of the format so you can use the data more seamlessly in other forms. XML is fully supported in Office 2003 through Word, Excel, and Access. Access allows you to import and export XML data as well as transform the data to and from other formats using XML related files, such as Extensible Stylesheet Language (XSL), which provides a flexible and consistent way to present your data. When you import and export XML data, you can use an XML Schema (XSD) ”a set of rules that defines the elements and content used in an XML file ”to ensure the data conforms to a defined structure. XML schemas and XSL transformations are created by developers who understand XML.

Import Data and Schema from XML

graphics/1_icon.jpg

Open the database in which you want to import.

graphics/2_icon.jpg

Click the File menu, point to Get External Data, and then click Import.

graphics/3_icon.jpg

Click the Files Of Type list arrow, and then click XML.

graphics/4_icon.jpg

Select and locate the XML data or schema file.

graphics/5_icon.jpg

Click Import.

graphics/6_icon.jpg

Click Options.

graphics/7_icon.jpg

Click an import option.

  • Structure Only

  • Structure And Data

  • Append Data To Existing Table(s)

graphics/8_icon.jpg

To select a transform, click Transform, click a transform, and then click OK.

graphics/9_icon.jpg

Click OK, and then, if necessary, click OK again.

graphics/11inf09.jpg

Export XML Data

graphics/1_icon.jpg

Open the database containing the object you want to export, and then select the database object.

graphics/2_icon.jpg

Click the File menu, and then click Export.

graphics/3_icon.jpg

If necessary, click the Save In list arrow, and then select the drive and folder where you want to save the file.

graphics/4_icon.jpg

Click the Save As Type list arrow, and then click XML.

graphics/5_icon.jpg

If necessary, type a new name for the file.

graphics/6_icon.jpg

Click Export.

graphics/7_icon.jpg

Select the export check boxes you want.

  • Data (XML)

  • Schema Of The Data (XSD)

  • Presentation Of Your Data (XSL)

graphics/8_icon.jpg

Click More Options.

graphics/9_icon.jpg

Click the tabs (Data, Schema, and Presentation) with the export type you want, and then select the related options you want.

graphics/10_icon.jpg

Click OK.

graphics/11inf10.jpg



Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

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