XML query in Excel

[dat]

hi all,

win xp, excel 2003.

i would like to ask if i can do any relational query on an xml data
source inside excel.

say, i have an xml document: employer.xml

<employerList>
<employer>
<Name>Guy1</Name>
<Department>Marketing</Deparment>
</employer>
<employer>
<Name>Guy2</Name>
<Department>Finance</Deparment>
</employer>
<employer>
<Name>Guy3</Name>
<Department>Accounting</Deparment>
</employer>
</employerList>

and i also have this xml document: departmentGroup.xml

<DepartmentGroup>
<Deparment>Marketing</Deparment>
<Deparment>Accounting</Deparment>
</DeparmentGroup>

Is it possible for me to make queries on these two xml data sources
(something similar to SQL or XQuery) to generate the following?

select <name> from employer.xml
where <deparment> in employer.xml = <department> in
departmentGroup.xml

so that i can get:
Guy1
Guy3

??? it is certain that i must work with XML format. or, is there any
similar method to do query on XML??

Thanks so much in advance,
isa

 

[Jamie Collins]

(e-mail address removed) (dat) wrote ...

i would like to ask if i can do any relational query on an xml data
source inside excel.

You could open them in an Excel workbook and query the workbook.

<Department>Marketing</Deparment>

You tags don't match, I think 'Deparment' is a typo (you are typing in the xml <g>?)

Jamie.

--