Experts,

For a project I am working on, I need to be able t produce XML files populated from a MS Access data store.
For example:



<MODEL model_name="Example Model">
    <EMPLOYEE_COLLECTION>
        <EMPLOYEE employee_code="x"
            employee_first_name="Joe"
            employee_last_name="Blow"
            <ACTIVITY_PROFICIENCY_COLLECTION/>
            <TEAM_ASSIGNMENT_COLLECTION/>
            <CUSTOM_FIELD_COLLECTION/>
            <EMPLOYEE_CALENDAR>
                <EMPLOYEE_AVAILABILITY>
                    <RECURRENCE_PATTERN pattern_name="Scheduling">
                        <vevent>
                        <dtstart>39083.0</dtstart>
                            <duration>720</duration>
                            <description>Every 1 week(s)  Monday Tuesday Wednesday Thursday Friday Saturday 7:0 to 19:0</description>
                            <rrule>FREQ=WEEKLY;BYDAY=MO,TU,WE,TH,FR,SA;BYHOUR=7;BYMINUTE=0;</rrule>
                        </vevent>
                    </RECURRENCE_PATTERN>
                </EMPLOYEE_AVAILABILITY>
                <EMPLOYEE_OFFTIME/>
            </EMPLOYEE_CALENDAR>
        </EMPLOYEE>
    </EMPLOYEE_COLLECTION>
</MODEL>

(incomplete, of course!)

In the past, to do things like this, I have generally relied on creating ordered DAO or ADO recordsets,
stepping through the recordsets, and using TextStream objects to write the relevant lines to the XML
files I need.

My question here is, would I be better off trying to use one of the XML-centric libraries to do this?  If
so, can anyone give me some pointers on where to start?

I am not asking for anyone to do my project for me--I just need a shove in the right direction.

Cheers,

Patrick