Importing XML Files into Access 2007 - Importing the XML file
(Page 2 of 4 )
Click on the External Data tab on the ribbon. In the menu, click on the XML File to import from an XML file.
Although the tooltip shows that you could either import or link to an XML file, when you click you will be presented with the next window which has only one option, Get External Data.
You may browse and point to the XML file on your drive. Here the file is on a network drive as shown.
When you choose the file and open, you will see the following window, Import XML, displayed. When you expand the student node you will see only the two items name and legacySkill as shown. The import did nothing with the attributes of the student in the original file. It appears to pick only repeated student nodes.
Assuming you import Structure and Data and click OK, the Get External Data window shows up with the "Save Import Steps" step. If you choose Save Import Steps by placing a check mark in the check box you will see it adds a few more controls to the window as shown. If this is some routine operation you do, you can leverage the integration of the Outlook program as described in the following window. Of course you need to place a check mark to create Create Outlook Task as well.
The saved steps are added to the current database with the Saved Imports shortcut in the External Data tab. When you want to run the steps you only need to click on this shortcut which opens the following window.
When you click on the Save Imports button, you create the table into which your imported data contained in the webstudents.xml file will be saved. This table will have a title corresponding to the repeated elements, namely student.
You will notice that the import failed to bring the student ids into the table, which is very similar to importing an XML file into Access 2003. The design of the student table is as shown in the next picture.
Choosing the Transform... control in the ImportXML window above does not provide any help as it only points to files of the type Transform in My Documents folder.
Next: Modifying the webstudents.xml file >>
More XML Articles
More By Jayaram Krishnaswamy
/ 4 
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th -1:00PM EST. 
