|
<< Click to Display Table of Contents >> XML and MS Access |
![]() ![]()
|
However, do not expect e.g. MS Excel or MS Access to readily read ClientDataSet XML data files!

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.
__________________________