Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

Posted on 2009-02-10
Medium Priority
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: http://www.questionmark.com/us/qml/index.aspx. The schema file was not accepted as an attachment.
Question by:Doug
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 23610713
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.

Author Closing Comment

ID: 31545311
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

569 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