Visual Basic Code to Produce XML file

We have simple Visual Basic project that entails producing an xml file for a product feed based upon the query results of a query from Microsoft Access. The VB code MUST be able to run in an MS Access database. The xml output must take the following format: <?xml version="1.0"?> <rss xmlns:g="[login to view URL]" version="2.0"> <channel> <title>Furniture Palace Products</title> <link> [login to view URL] </link> <description>This is a sample feed for the [login to view URL] product feed</description> <!-- First item shows what attributes are required and recommended--> <item> <!-- The following attributes are always required --> <title>Empress High Back Dining Chair</title> <link>[login to view URL]</link> <description> This fabulous high backed dining chair features a smooth square back and gently tapered legs. The streamlined design together with the neutral linen upholstery is perfect for the modern contemporary home or office. Free Delivery Nation Wide.</description> <g:id>DN10058</g:id> <g:brand>Furniture Palace</g:brand> <g:condition>new</g:condition> <g:price>159.00 AUD</g:price> <!-- The following attributes are not required, but are recommended --> <g:sale_price>99.00 AUD</g:price> <g:availability>in stock</g:availability> <g:quantity>55</g: quantity > </item> We will provide .mdb database with sample data and pre-written query which will produce the content required.