• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

7. External Programs and Data > 64. Export XML Data Sanely

Export XML Data Sanely

Working around the thorny issue of exporting related data to XML.

Exporting a single table to XML produces some easily reusable data. Exporting multiple tables to XML, however, might not produce data that other applications can use; it all depends on how you structured your tables and relationships. You can solve this problem in two ways: restructure your data or use a query to export data that’s been unnormalized.

For our initial example, we’ll start with a database containing a table that defines a list of books. Figure 7-30 shows the Design view for that table. It includes six fields of three different types.

A simple table for export
Figure 7-30. A simple table for export

For the initial tests, this table contains just a little bit of information. Exporting mature tables with thousands of records can quickly produce large XML files—definitely useful in real life but difficult for initial analysis. Figure 7-31shows a partial view of the content in the test table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint