Importing XML Files into Access 2007
(Page 1 of 4 )
In an earlier article on Access 2003, importing an XML file into the Access application was described. It was shown that, while exporting data from a table was easier, importing an XML file was not straightforward. In this tutorial an XML file will be imported into Microsoft Access 2007, the latest version of MS Access for comparison.
Creating a blank database
From Start -->Microsoft Office choose MS Access 2007 and click to open the program. In the open program click on the Microsoft Office button and from the drop-down menu choose the New...option to create a blank database, ImportXML as shown. After providing a name when you hit the create button you will have created a blank database with a default Table1 with a single row.
Importing an XML File
The XML file that will be imported is shown in the next listing, a file used in several other tutorials on the DevShed sites. This file is on the present machine as well as on some networked drives.
<?xml version="1.0"?>
<wclass>
<!-- My students who attended my web programming class -->
<student id="1">
<name>Linda Jones</name>
<legacySkill>Access, VB5.0</legacySkill>
</student>
<student id="2">
<name>Adam Davidson</name>
<legacySkill>Cobol, MainFrame</legacySkill>
</student>
<student id="3">
<name>Charles Boyer</name>
<legacySkill>HTML, Photoshop</legacySkill>
</student>
<student id="4">
<name>Charles Mann</name>
<legacySkill>Cobol, MainFrame</legacySkill>
</student>
</wclass>
Next: Importing the XML file >>
More XML Articles
More By Jayaram Krishnaswamy
/ 6 
