Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jan 2009
    Location
    UK
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XML and Accessm 2003 Databases

    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>

  • #2
    Regular Coder
    Join Date
    Jun 2008
    Location
    SE Wisconsin, US
    Posts
    222
    Thanks
    1
    Thanked 20 Times in 20 Posts
    Try Application.ImportXML. More information available from Microsoft.
    Milwaukee Web Designer and SEO Milwaukee Firm specializing in ASP.Net, C#, VB.Net, SQL Server and Access.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •