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.
Next: Displaying retrieved XML in an HTML document >>
More XML Articles
More By Jayaram Krishnaswamy
