Export to XML File

Use this option to write data to an XML formatted document file.

You will be prompted for the name of the output file.

image\DataGridExportToXML.gif

You do not need any special software to write the XML file.

The output will contain both a schema and the data.

You can read the export file using most text editors.

 

Example XML Output From Random Names Generator

<?xml version="1.0" standalone="yes"?>

<NewDataSet>

<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

<xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:MainDataTable="Table" msdata:UseCurrentLocale="true">

<xs:complexType>

<xs:choice minOccurs="0" maxOccurs="unbounded">

<xs:element name="Table">

<xs:complexType>

<xs:sequence>

<xs:element name="FirstName" type="xs:string" minOccurs="0" />

<xs:element name="MiddleInitial" type="xs:string" minOccurs="0" />

<xs:element name="LastName" type="xs:string" minOccurs="0" />

<xs:element name="Gender" type="xs:string" minOccurs="0" />

<xs:element name="BirthDate" type="xs:string" minOccurs="0" />

<xs:element name="AddressLine1" type="xs:string" minOccurs="0" />

<xs:element name="AddressLine2" type="xs:string" minOccurs="0" />

<xs:element name="City" type="xs:string" minOccurs="0" />

<xs:element name="StateProvince" type="xs:string" minOccurs="0" />

<xs:element name="ZipPostalCode" type="xs:string" minOccurs="0" />

<xs:element name="TelephoneNumber" type="xs:string" minOccurs="0" />

<xs:element name="EmailAddress" type="xs:string" minOccurs="0" />

<xs:element name="NationalId" type="xs:string" minOccurs="0" />

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:choice>

</xs:complexType>

</xs:element>

</xs:schema>

<Table>

<FirstName>Angela</FirstName>

<MiddleInitial>Y</MiddleInitial>

<LastName>Hofman</LastName>

<Gender>Female</Gender>

<BirthDate>2000/07/05</BirthDate>

<AddressLine1>880 Meacham Rd</AddressLine1>

<AddressLine2 />

<City>Arlington</City>

<StateProvince>IA</StateProvince>

<ZipPostalCode>50606</ZipPostalCode>

<TelephoneNumber>1-319-555-0194</TelephoneNumber>

<EmailAddress>ycubeyyweyzy@example.com</EmailAddress>

<NationalId>000-95-0000</NationalId>

</Table>

</NewDataSet>