Importing XML into MS Access 2003 - Importing the same file into Excel 2003
(Page 3 of 4 )
The premise for this attempt at importing is that all Office products, especially the 2003 vintage, have strong support for XML. The XML import steps from MS Excel are similar to the ones from MS Access, and will not be repeated except to show what happens when the import button is clicked after following the trail Data-->XML--> Import.... The next MS Excel message window pops up saying that the XML is lacking a schema and offers to create one. This is in Microsoft's best tradition of being user friendly.
Clicking OK to this message will bring up the cell locator where you want to park your data as shown. It does not, however, describe how the schema looks. You have the option of creating a new worksheet or using an existing worksheet.
Since there is only one worksheet in this otherwise blank XLS file, the option to click the OK button was taken. This brings in the data with every detail in it as shown. Now you see that not only did it bring in the child nodes correctly, it also brought in the student node details correctly. The XLS file is saved to xml.xls (it is saved to My Documents by default).
Now if you import the xml.xls file into MS Access you will get the complete information because it now happens to be an Excel table import. This is no different from importing worksheet data to MS Access.
Next: One more time >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
