xml spy
Previous  Top  Next
Convert - How to...

The How to... sections in this manual go into more detail about a specific subject in a task oriented way, and are generally sequential in nature. Tasks may build upon previous ones and may also use their data (or files) further on in the section.

In this section you will learn how to:

·Export hierarchical XML data, using the Data_shape.xml file supplied with XML Spy, and create a MS Access database called "Data_shape.mdb".  
 
·Define an ODBC (and ADO) connection to the "Data_shape.mdb" database.  
 
·Import a single table using the ODBC connection.  
 
·Import specific (hierarchical) portions of the database data, using ADO data shape commands.  
·Create Identity constraints in a schema, enabling you to import database data hierarchically - or create an XML document based on a database schema.  

Files used in this How to... section:

 
·Data_shape.xml file, from which you will create a MS Access database  
·Shapes.txt file, a file containing all the shape strings used in this section to import data using the ADO shape string function  
·No-constraints.xsd file, for which you will create Identity constraints, enabling you to import specific data sets hierarchically.  

Previous  Top  Next

⌐ 2002 Altova