How do I parse QML data into an MS Access table?

Posted on 2009-02-10
Last Modified: 2013-11-15
I need to parse QML (Question Markup Language) formatted data into a database table. My data are already in Access but they are in a single field, separated by QML tags. I need to get the QML formatted data in into a database table (i.e., broken into fields). I found a website that provided an XML Schema Definition (XSD) of QML but I don't know how to apply the schema to extract the data I have into a format I can use.  Can anyone help? Here is the link for the XML Schema: The schema file was not accepted as an attachment.
Question by:Doug
    LVL 84

    Accepted Solution

    Looks to me as if you'll have to build your own QML parser. Seems that all the major elements are delimited by xs:<some name>, with various minor elements and properties. I did a quick search and didnt find anything, but you may be able to with a more thorough search.
    LVL 7

    Author Closing Comment

    Thank you for the help. Not sure how I'll handle my situation. I am in between having only enough data to warrant someone manually capturing the data and not having enough project money to allow my group to develop a parser, even though this issue will probably come up again in the future.  When I get a chance I'll do a more thorough search to see if anything else is out there. Thanks again!

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now