XML and MS Access

<< Click to Display Table of Contents >>

Navigation:  Export > ClientDataSet export XML/CDS >

XML and MS Access

Previous pageReturn to chapter overviewNext page

ClientDataSet XML vs. MS Access XML

However, do not expect e.g. MS Excel or MS Access to readily read ClientDataSet XML data files!
SimpleTable
MS Access exporting equivalent [Members] data to XML rather would create a completely different data file like this:

<?xml version="1.0" encoding="UTF-8"?>

<dataroot xmlns:od="urn:schemas-microsoft-com:officedata" generated="2023-01-07T12:34:56">

  <Members>

    <Member-ID>101</Member-ID>

    <First_x0020_Name>Eva</First_x0020_Name>

    <Family_x0020_Name>Smith</Family_x0020_Name>

  </Members>

  <Members>

    <Member-ID>102</Member-ID>

    <First_x0020_Name>Adam</First_x0020_Name>

    <Family_x0020_Name>Wright</Family_x0020_Name>

  </Members>

</dataroot>

and optionally accompanied by a hugely verbose *.xds schema file.
So, targetting an MS Access database without binary data, exporting as simple CSV text files is to be preferred.

See also ClientDataSet XML files.

__________________________
PdxEditor Application Help, 14 July 2026; © 2010-2026 Niels Knabe