My.ADVISOR.com Sign-In
ID
Password

Member Center / Sign-Up
Go to Article
Advanced Search 

ACCESS DEVELOPMENT

Simplify XML Querying with Microsoft Access

You don't need to learn XPath or XQL to query XML. Create temporary tables that persist XML data for easier data access and manipulation.

 DOWNLOAD (138,453 bytes) -- Access 2000 database and two sample XML files.
By Jonathan Hettena

THIS ARTICLE IS SUBSCRIBER-ONLY
To read this article you must have a current Subscription or Passport for:
DATABASED ADVISOR
or
MICROSOFT ACCESS ADVISOR
or
MICROSOFT OFFICE ADVISOR
or
MICROSOFT PRO DEVELOPMENT ADVISOR
If you have a correct subscription, sign-in (pink box above) to view the complete article and access any Download.

Purchase or renew your Subscription or Passport at www.AdvisorStore.com.

Click this link for help with subscriber online access.

About this Article:

Dynamically create and populate an Access table from both attribute- and element-based XML.

Jonathan Hettena is a senior associate with Lehman Brothers in New York. He has a Bachelor of Science in Business from the State University of New York. He has spent the past seven years developing Microsoft Office solutions, predominantly with Access for the financial district. Jonathan currently works with XML, Access, and Visual Basic. hettena@mindspring.com.

Keyword Tags: Application Development, Database, Microsoft, Microsoft Access, XML

ADVISORAMA
Even in the darkest moments, you can always find something that'll make you smile.
-- Capt. Benjamin Sisko, Star Trek: Deep Space 9

ARTICLE INFO

DataBased Advisor

Print Edition: December 2001, Page 16

SUBSCRIBER ONLY ARTICLE LOCKED


 Article files are on this issue's Resource CD.
File: Access 2000 database and two sample XML files.
DOWNLOAD: 138,453 bytes

SUBSCRIPTION STATUS
You are not signed-in. If you are a subscriber to this publication, sign-in above to access locked articles. To subscribe or renew go to www.AdvisorStore.com.

Subscribe to DATABASED.ADVISOR.com

Get it all -- every current and past ADVISOR tech/business publication, now all-in-one subscription, with new articles and a huge reference library packed with expert advice, how-to and downloads. Subscribe now to get it all.

DataBased.Advisor.com

Subscribe to FileMaker Advisor Magazine

Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.

FileMaker.Advisor.com

Subscribe to Advisor Basics of FileMaker Pro

Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!

FileMaker.AdvisorBasics.com

Showcase Your Smarts

Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!

AdvisorTips.com

Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2008 Advisor Media, Inc. All Rights Reserved.
Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
Hosted by Prominic.NET Website powered by
LOTUS SOFTWARE
HETTJ01 posted 12/01/2001 modified 01/07/2009 03:35:47 AM ztdbms/ztdbms
domino-144.advisor.com my.advisor.com 01/07/2009 09:47:31 AM