MS Project extended attributes

See more:

VB

Microsoft

I am trying to manipulate the contents of a large MS project (2010) into a sql database for complex reporting purposes. (Not all the data needed for the reports is in the project)

The project is making use of four custom text fields and a custom date field. When I save the project as an xml file I see these columns in the extended attributes as follows:

<ExtendedAttributes>
    <ExtendedAttribute>
        <FieldID>188743731</FieldID>
        <FieldName>Text1</FieldName>
        <Alias>Master job</Alias>
        <Guid>000039B7-8BBE-4CEB-82C4-FA8C0B400033</Guid>
        <SecondaryPID>255869028</SecondaryPID>
        <SecondaryGuid>000039B7-8BBE-4CEB-82C4-FA8C0F404064</SecondaryGuid>
    </ExtendedAttribute>

The problem I am having is finding the extended attributes in the project object as I need to use the Alias value as a column name in a sql join to another table
I am accessing the tasks and calendar details with no problem, but cannot figure out how to get these details.
Any help will be much appreciated
Grant