You can open XML files as datasets in Exportizer using these ways:

1. Opening through connection string. Select ADO interface, then choose Connection string option and write a connection string. Use this way if some ODBC driver for XML is installed.

2. Opening by specifying file name. Select ADO interface, then choose File option and then browse for the needed file.


  1. When building a connection string based on ODBC diver, please make sure the driver installed and the bit-version of it matches the bit-version of the application (32 or 64).
  2. If you chose opening by specifying file name, Exportizer first tries to find an appropriate driver for it. If the driver not found or if it failed to open the file, Exportizer tries to open it as ADODB.Recordset object. In the last case, the XML file must contain a record set and must conform W3C XML-Data specification (you can get such files, for example, when exporting data to XML in Exportizer using ADO schema).
    Example of supported XML file:
    <xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
    <s:Schema id='RowsetSchema'>
    	<s:ElementType name='row' content='eltOnly'>
    		<s:AttributeType name='ID' rs:number='1' rs:nullable='true' rs:writeunknown='true'>
    			<s:datatype dt:type='float' dt:maxLength='8' rs:precision='15' rs:fixedlength='true'/>
    		<s:AttributeType name='FIRSTNAME' rs:number='2' rs:nullable='true' rs:writeunknown='true'>
    			<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='12'/>
    		<s:AttributeType name='LASTNAME' rs:number='3' rs:nullable='true' rs:writeunknown='true'>
    			<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='16'/>
    		<s:AttributeType name='CITY' rs:number='4' rs:nullable='true' rs:writeunknown='true'>
    			<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='16'/>
    		<s:AttributeType name='COUNTRY' rs:number='5' rs:nullable='true' rs:writeunknown='true'>
    			<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='16'/>
    		<s:extends type='rs:rowbase'/>
    	<z:row ID='1' FIRSTNAME='Sandra' LASTNAME='Bush' CITY='Portland' COUNTRY='United States'/>
    	<z:row ID='2' FIRSTNAME='Eric' LASTNAME='Miles' CITY='Edmonton' COUNTRY='Canada'/>
    	<z:row ID='3' FIRSTNAME='Berndt' LASTNAME='Mann' CITY='Hamburg' COUNTRY='Germany'/>
    	<z:row ID='4' FIRSTNAME='Marek' LASTNAME='Przybylsky' CITY='Krakow' COUNTRY='Poland'/>
    	<z:row ID='5' FIRSTNAME='John' LASTNAME='Hladni' CITY='Bedford' COUNTRY='United States'/>
    	<z:row ID='6' FIRSTNAME='Bogdan' LASTNAME='Vovchenko' CITY='Kyiv' COUNTRY='Ukraine'/>
    	<z:row ID='7' FIRSTNAME='Paul' LASTNAME='Vogel' CITY='Hamburg' COUNTRY='Germany'/>
    	<z:row ID='8' FIRSTNAME='Ion' LASTNAME='Rotaru' CITY='Kishinev' COUNTRY='Moldova'/>
    	<z:row ID='9' FIRSTNAME='Mehmed' LASTNAME='Rabbani' CITY='Liege' COUNTRY='Belgium'/>
    	<z:row ID='10' FIRSTNAME='Rita' LASTNAME='Hagen' CITY='Vienna' COUNTRY='Austria'/>
    	<z:row ID='11' FIRSTNAME='Andreas' LASTNAME='Muller' CITY='Berlin' COUNTRY='Germany'/>
    	<z:row ID='12' FIRSTNAME='Hans' LASTNAME='Petersen' CITY='Copenhagen' COUNTRY='Denmark'/>
    	<z:row ID='13' FIRSTNAME='Shimon' LASTNAME='Rabinovich' CITY='Tel Aviv' COUNTRY='Israel'/>
    	<z:row ID='14' FIRSTNAME='Rick' LASTNAME='Yonley' CITY='Miami' COUNTRY='United States'/>
    	<z:row ID='15' FIRSTNAME='Jose' LASTNAME='Pereira' CITY='Madrid' COUNTRY='Spain'/>