D
dave
excuse the multiple post, this is also in the xsl group, but is probably more
specific to access but i didn't spot this group last night when looking for
where to post this.
Please pardon what is probably a newbie type question, but i have been
looking at raw xslt stuff and not getting the info i need, and just don't
have time to play around right now.
Starting with xml that looks like this where there are multiple tables
identified with tagnames i need to filter it so that i can select which
tables i want to import into Access. The real file has several tables that
have tagnames that aren't valid table names for Access, and that i don't
want anyway. I would prefer to select table names to keep rather than ones
to throw away in case someone adds another table i don't care about. any
hints?? so far most of my attempts have resulted in various errors from
Access about the transform resulting in something that couldn't be
imported... or just plain complaining about my poor structure.
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<root>
<table tagname="tablename1">
<tablename1 rownum="0">
<field1>1</field1>
<field2>2</field2>
</tablename1>
<tablename1 rownum="1">
<field1>3</field1>
<field2>4</field2>
</tablename1>
</table>
<table tagname="tablename2">
<tablename2 rownum="0">
<field1>11</field1>
<field2>22</field2>
</tablename2>
<tablename2 rownum="1">
<field1>33</field1>
<field2>44</field2>
</tablename2>
</table>
</root>
specific to access but i didn't spot this group last night when looking for
where to post this.
Please pardon what is probably a newbie type question, but i have been
looking at raw xslt stuff and not getting the info i need, and just don't
have time to play around right now.
Starting with xml that looks like this where there are multiple tables
identified with tagnames i need to filter it so that i can select which
tables i want to import into Access. The real file has several tables that
have tagnames that aren't valid table names for Access, and that i don't
want anyway. I would prefer to select table names to keep rather than ones
to throw away in case someone adds another table i don't care about. any
hints?? so far most of my attempts have resulted in various errors from
Access about the transform resulting in something that couldn't be
imported... or just plain complaining about my poor structure.
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<root>
<table tagname="tablename1">
<tablename1 rownum="0">
<field1>1</field1>
<field2>2</field2>
</tablename1>
<tablename1 rownum="1">
<field1>3</field1>
<field2>4</field2>
</tablename1>
</table>
<table tagname="tablename2">
<tablename2 rownum="0">
<field1>11</field1>
<field2>22</field2>
</tablename2>
<tablename2 rownum="1">
<field1>33</field1>
<field2>44</field2>
</tablename2>
</table>
</root>