Link to home
Start Free TrialLog in
Avatar of Doug
DougFlag for United States of America

asked on

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

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: http://www.questionmark.com/us/qml/index.aspx. The schema file was not accepted as an attachment.
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Doug

ASKER

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!