Microsoft Access
  Home arrow Microsoft Access arrow Page 4 - Importing XML into MS Access 2003
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Mobile Linux 
App Generation ROI 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
MICROSOFT ACCESS

Importing XML into MS Access 2003
By: Jayaram Krishnaswamy
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 8
    2006-07-25

    Table of Contents:
  • Importing XML into MS Access 2003
  • Importing the file into MS Access 2003
  • Importing the same file into Excel 2003
  • One more time

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Importing XML into MS Access 2003 - One more time


    (Page 4 of 4 )

    Now we go back to an earlier step and use the 'transform...' button to see if we can succeed in importing the original webstudents.xml file. When the Transform... button is clicked during the import operation you get the following window. Again this is not a very informative screen unless there was a choice of transforms already present.

    Clicking on the Add... button, the following window opens. It gives slightly more information than the previous screen. The program is looking for a file of type xsl or xslt. These are the well know extensible style languages. This will not be useful to the user as it gives him no clue for browsing to the file that will complete the import. Digging a little deeper, you will find that there are two wizards lurking in the labyrinths which are not listed, the Import XML Wizard and the Export XML Wizard.

    Summary

    Using the Import XML utility in MS Access 2003 failed to completely import a very simple file as some component in the MS Access 2003 may be missing, although it was verified that none of the functionality was disabled. The import was tested with Microsoft Office Access 2003 (11.6566.6568) SP2 on Office XP Professional Media Center Edition. However, MS Excel seems to do a nice job of the importing.


    DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

       · Access 2003 does not seem to do a good job, but MS Excel does. Now you have a two...
     

    MICROSOFT ACCESS ARTICLES

    - Linking SQL Express 2005 Tables to MS Access...
    - Working with Access Projects in Access 2007
    - Exploring Access 2007
    - Working with Stored Procedures in an MS Acce...
    - Creating and Using Action Queries
    - Creating Data Access Pages with Charts using...
    - Advanced Ideas using VBA
    - VBA Details
    - Updating Records in MS Access
    - Using ADO`s Record Object with URLs
    - Exporting XML from MS Access 2003
    - Importing XML into MS Access 2003
    - On Using Pass-through Queries in MS Access
    - Distributed Queries in MS Access
    - Configuring a Linked Microsoft Access Server...





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway
    Stay green...Green IT