...

View Full Version : XML and Accessm 2003 Databases



rose21
01-21-2009, 06:04 PM
I'm a tiny bit stuck, I'm doing a shopping site that has the data in a XML table that has been put into a HTML page using JavaScript, the question is how do I add a button to add this data in the table to access 2003 database table so it can be imported to an HTML table, any ideas would help. The code below is the XML with the values.


<CATALOG>
<BAG>
<PICTURE></PICTURE>
<TYPE>Torte</TYPE>
<COLOUR>Pink</COLOUR>
<SIZE>Small</SIZE>
<PRICE>12</PRICE>
</BAG>

<BAG>
<PICTURE></PICTURE>
<TYPE>Cluth</TYPE>
<COLOUR>Black</COLOUR>
<SIZE>meduim</SIZE>
<PRICE>8</PRICE>
</BAG>

<BAG>
<PICTURE></PICTURE>
<TYPE>Shopper</TYPE>
<COLOUR>Blue</COLOUR>
<SIZE>Large</SIZE>
<PRICE>15</PRICE>
</BAG>

<BAG> <PICTURE></PICTURE>
<TYPE>Shopper</TYPE>
<COLOUR>White</COLOUR>
<SIZE>Small</SIZE>
<PRICE>10</PRICE>
</BAG>

<BAG>
<PICTURE></PICTURE>
<TYPE>Tote</TYPE>
<COLOUR>Purple</COLOUR>
<SIZE>Extra Large</SIZE>
<PRICE>25</PRICE>
</BAG>



</CATALOG>

demtron
01-23-2009, 09:47 PM
Try Application.ImportXML. More information available from Microsoft (http://msdn.microsoft.com/en-us/library/aa221346(office.11).aspx).



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum