Importing XML Files into Access 2007 - Modifying the webstudents.xml file

(Page 3 of 4 )

It is possible to bring the XML file contents into an Access table if the attributes are replaced by elements as shown in the next listing. The basic data remains the same by this conversion for this particular file.

<?xml version="1.0"?>
<?xml version="1.0"?>
<Xstudent> 
<!-- My students who attended my web programming class --> 
<student> 
<id>1</id> 
<name>Linda Jones</name>  
<legacySkill>Access, VB5.0</legacySkill> 
</student> 
<student>
<id>2</id> 
<name>Adam Davidson</name>  
<legacySkill>Cobol, MainFrame</legacySkill> 
</student> 
<student>
<id>3</id>  
<name>Charles Boyer</name>  
<legacySkill>HTML, Photoshop</legacySkill> 
</student> 
</Xstudent>

When you bring in the above file by following the previously mentioned import steps and browse to the above file, the Import XML window displays the following.

Now if you bring in structure and data you will successfully add a student table  with its data as shown in the next picture.

Next: Another method for bringing in an XML file >>
 

More XML Articles
More By Jayaram Krishnaswamy

Comments On: Importing XML Files into Access 2007

· Access 2007 fails in a manner similar to Access 2003 while importing...   >>> Post your comment now!