The three main XML tabular-formats that the XML driver can access are described in the following table. In some instances, you may need to define hints to help the XML driver read the tabular-format of an XML document correctly. See Configure Location Dialog Box Descriptions.

Table 1. Common Tabular Formats for XML Documents
Format Description
ADO 2.5 persisted files These files are identified by a unique schema namespace URL. Although ADO uses the same data types defined by XML-Data, the data types use extensions, such as adding a maximum column width for string columns. ADO 2.5 persisted files are identified by the following unique XML element:
<xml 	xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" 
    xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-
    00AA00C14882" 
    xmlns:rs="urn:schemas-microsoft-com:rowset" 
    xmlns:z="#RowsetSchema">
DataDirect Format This XML format conforms to the W3C recommendation for XML schema, Working Draft April 07, 2000. These files are identified by the following unique XML element (schema namespace URL):
<table targetNamespace=
"http://www.merant.com/namespaces/datadirect/xmlrecordset" 
xsi:schemaLocation=
"<http://www.merant.com/namespaces/datadirect/xmlrecordset/EMP.xml>" 
xmlns="http://www.w3.org/1999/XMLSchema" xmlns:xsi=
"http://www.w3.org/1999/XMLSchema-instance" xmlns:rs=
"http://www.merant.com/namespaces/datadirect/xmlrecordset"><table xmlns="http://www.w3.org/1999/XMLSchema"
    xmlns:xsi=    "http://www.w3.org/1999/XMLSchema-instance"
    xmlns:rs=    "http://www.datadirect-technologies.com/namespaces
    /datadirect/xmlrecordset">
Microsoft Data Islands These islands are identified by the <XML> tag in an HTML document. The Data Island can be embedded in the HTML document. Data Islands can include the following Schema definition and namespace:
<Schema xmlns="urn:schemas-microsoft-com:xml-data"
xmlns:dt="urn:schemas-microsoft-com:datatypes">