How Do I search For certain data in xml using VBA code?

[Gary]

I have an attribute-centric xml file which can't be imported directly into
Access. In addition have have look into KB article#285329 and I don't know
how to change the xsl stylesheet to bring in the xml data I have.

Let me describe what I need to accomplish:

1) I am given an xml file only. No other format is availble.
2) I need to scan the file to look for key words and determine their
values.
3) I also need to scan for the employee skill set if it matches a certain
skill set I am looking for and get itheir employee ID number.

That is all I need to do.

Can someone please give me suggestion on the best approach to this problem??

I am using Access 2000 and if needed, I can use Access 2003. The KB article
needed Access 2003 or it gave an error. I understand vba code. I am also
using xp os.

I was thinking on reading the file and looking for the key words, but I have
no idea in bring in an xml file into access???? I can't bring it in as a
table, and I don't think I can use an DAO.Recordset????? I don't know what
ADO recordset does.


Any help would be deeply appreciated!!!

Thank You,

Gary

 

[Jeanette Cunningham]

Gary,
I looked through some articles from microsoft about importing xml data.
I found one article that uses ADO to import attribute-centric xml data into
access.
I haven't tried it, but hope it helps you.

Jeanette Cunningham