An XML data island is a piece of well-formed XML embedded into an HTML file. This article will show you how to retrieve data in an XML format from a database using ADO; you will also learn how to bind this data into an HTML document.
Displaying ADO Retrieved Data with XML Islands - Data types in Access 2003 and XML file (Page 5 of 7 )
In MS Access there are several data types that are typical to its Jet Library. In order to look at how the data goes over into XML, a table, called 'Whimsical' was contrived which has all the data types but contains only a single row of data. This was opened just like the previous table and the saved file was examined. In the next picture you see the table and in the one that follows, you see the 'schema' section. The data types, 'bitmap', and 'hyperlink' can take up a large amount of space. This one row of data saved to file takes up as much as 0.5 MB.
This is the 'Schema' section of the above file. Review each of the data types and you'll see the corresponding dt:type in the XML file.