Share this Page URL

Chapter 16. Working with XML Data in Acc... > Presenting XML Data with Access - Pg. 578

Working with XML Data in Access 578 · You need to capture survey data from non-networked, remote locations within your organization. Each site maintains a local Web site, but the locations are locked down and have limited net- working abilities. You might create a master Access database that will store the data collected from the remote sites. You export your table structure to XML and send the output to the remote locations for use in capturing the survey data. The remote locations then send the updated .xml file back to you for importing into the master Access database and for analysis. In each of these cases, the XML document serves to capture as well as present data. A schema is needed to preserve the structure and integrity of the data that is being entered. We'll look more closely at how this works in the next section. Just the Steps Export an XML document with an embedded XSD 1. 2. 3. 4. Open a table in an existing database. On the File menu, click Export. In the Save As Type drop-down list, select XML. Select the path to which you want to save the .xml files, and click Export All. When the Export XML dialog box appears, leave the Presentation Of Your Data (XSL) check box cleared, and click the More Options button. Select the Schema tab. Make sure the Export Schema and Include Primary Key And Index Information check boxes are selected. In the Export Location area, click the Embed Schema In Exported XML Data Document option. Click the Browse button, and verify that the exported files will be saved in the location you want. Click the OK button. 5. 6. 7. 8.