Importing XML into MS Access 2003 - Importing the file into MS Access 2003
(Page 2 of 4 )
Create a new MDB file and change its default to xml.mdb. You may save it to the default directory. This database has no tables, or other objects except for the utilities. Click on Import... hyperlink by following the trail File -->Get External Data.... as shown.
This opens up the default folder My Documents with a default file type which may be one of several different MS Access file extensions, but not XML. Since the file used in this tutorial is on the local web server, this was accessed as shown in the next picture.
When you highlight the webstudents.xml file, click on the Import button. The next window shown in the next picture, Import XML, pops up as shown. In this picture the student node has been expanded. You can see the two child nodes of the XML file.
Now if you click on the Options button you will see three options that you can use to import together with the default option, Structure and Data. While the options button is dimmed (inactive), a new button, Transform. is spawned as shown.
.
For now, just click on the OK button. This brings up the following MS Access message, and a new table is created with the name student (corresponding to the node).
The student table is now part of the database and you can create all other MS Access objects such as Form, Report, and Data Access Pages. Observing the table details, you will notice that although all student information showed up correctly, the student IDs are missing. So the import is not really complete. There is something missing in the import which is not quite apparent. The program does not give any indication as to what might be missing.
Next: Importing the same file into Excel 2003 >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
