Export A2000 in XML format

R

Ryan W

Can anyone tell me if there is a way that I can export data from A2000 in XML
format? Any websites? Forums? Books? Or would it be easier to upgrade myself
to 2002/2003?

Thank you for your time, Ryan
 
R

Ryan W

Rick,
Thank you for posting this code. Not sure of where I would place/use it
though? Would this be code for a form? I am still green when it comes to the
back end of Access. Thank you for your assistance.
 
T

thou

i want to figure out on how to export access 2003 tables to XML files with a
basic format like bellow:-
<?xml version="1.0" encoding="UTF-8"?>
<Class>
<student name="Blondie Bush">
<id>1</id>
<height>172 cm</height>
<weight>55 kg</weight>
<hobby>playing guitar</hobby>
<quote>life to the fullest</quote>
<image>images/blondie.jpg</image>
</student>
</Class>

I'm exporting one of the table and the xml output as showing below;-

<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:eek:d="urn:schemas-microsoft-com:eek:fficedata">
<Class>
<student>
<id>1</id>
<height>172 cm</height>
<weight>55 kg</weight>
<hobby>playing guitar</hobby>
<quote>life to the fullest</quote>
<image>images/blondie.jpg</image>
</student>
</Class>
</dataroot>

as you might notice there is a differences between the two xml files. how to
get rid the <dataroot> and how to make it export the <student name="Blondie
Bush"> format instead of <student>?
my xml structure is strict becource it will be parsed into flash
application. so it would be compulsory to comply with those given xml
structure (i cant change/modify on how flash parsed xml). so the only option
is to make access export into the very similar structure. i dunno much about
access 2003 and am still learning..

Thanks
 
Top