0

Hi,

I am trying to output some data from sql db within excel to XML.

I am updating the sql db from the excel worksheet and then outputting the records from the db to xml.

I have used CDATA to parse html within xml but i can only get one record from the db although there are more.

Here is a piece of the code:

& "<BODY> <![CDATA[<head><meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"" />" _
& "<title>Untitled Document</title>" _
& "</head>" _
& "<body><table width=""100%"" border=""1"">" _
& "<tr><th scope=""col"">Supplier Branch</th>" _
& "<th scope=""col""><p>" & "]]>" & s1.Range("supplier") & "<![CDATA[</p></th>" _
& "</tr>" _
& "<td colspan=""5"">&nbsp;</td>" _
& "<tr>" _
& "<th scope=""col"">PO Number</th>" _
& "<th scope=""col"">" & "]]>" & rs1!PurchaseOrderNo & "<![CDATA[ </th>" _
& "<th scope=""col"">&nbsp;</th>" _
& "<th scope=""col"">Job ID</th>" _
& "<th scope=""col""><p>" & "]]>" & rs1!jobid & "<![CDATA[</p></th>" _
& "</tr>" _
& "<tr>" _
& "<td colspan=""5"">&nbsp;</td></tr>";
Print #f, "<tr>" _
& "<td>QTY</td>" _
& "<td>Part No</td>" _
& "<td>Description</td>" _
& "<td>Unit Price</td></tr>" _
& "<tr><td>" & rs1!quantity & "</td>" _
& "<td>" & rs1!PartNo & "</td>" _
& "<td>" & rs1!PartDescription & "</td>" _
& "<td>" & rs1!PartPrice & "</td>" _
& "<td>&nbsp;</td>" _
& "</tr>" _
& "</table>" _
& "</body>" & "]]>" & "</BODY>" _

Now there are more than 1 rows of quantity, PartNo, PartDescription and PartPrice. What i need is some sort of loop there to go through the recordset and output all records in a html table within xml which I have not been able to implement.

Any help will be highly appreciated.

Thanks.

2
Contributors
5
Replies
6
Views
6 Years
Discussion Span
Last Post by AndreRet
0

I think this might be a nut cracker on VB4/5/6 forum. To ensure a quicker response or solution, try the web development forums, most of your code is HTML. I have asked the mods to have a look and see if they can place it for you.:)

0

yes but this is not web development it is excel vba

0

Very true, but html is VERY similar, which means the help you will receive will be much better than what you will receive here.

0

Thanks AndreRet.I will open a thread in there.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.