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

18. XML > 18.1. Import XML Structured as Elements

18.1. Import XML Structured as Elements

Problem

You need to import simple XML data into a new table.

Solution

You can import XML into a new table from the File menu when the Tables category is selected in the Objects pane by following these steps:

  1. Open 18-01.MDB.

  2. Choose File Get External Data Import to bring up the Import dialog box.

  3. In the Files of type drop-down list at the bottom of the dialog box, select XML (*.xml, *.xsd).

  4. In the File name dialog box, navigate to the XML file you want to import, and click Import, which will load the XML Import dialog box. The samples include an XML file named 18-01.XML that you can use.

  5. Expand the plus sign (+) to show the structure of the XML file and click the Options button to expand the dialog box, as shown in Figure 18-2.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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