Generating XML using VB Script

[lavadan]

Hi Folks,

I am a newbie to VB Script. I need to generate the following XML document using VB Script. Can you please advise me on this? I can manage at least if I know the concept of generating XML using VB Script.

<?xml version='1.0"?>
<authors>
<author>
<firstname>john</firstname>
<lastname>norton</lastname>
<publishingcompany>westwind inc</publishingcompany>
<year>2007</year>

In the above XML document, I will get the author name from a text file (about 10,000). The publishing company and the year are the same for all the authors.

I can do this using SQL Server but we don't have a table containing author information and we have only read database. So can I generate this XML document using VB script? Please share your ideas.

[Dököll]

I am a newbie to VB Script. I need to generate the following XML document using VB Script ... I can do this using SQL Server but we don't have a table containing author information and we have only read database. So can I generate this XML document using VB script? Please share your ideas.

I can teach you how to do that in VB, pretty simple, I am sure you already have the skills, all you'd need is guidance, truly. :-)

In a bit, and oh, I have no idea about VB Script so do stay tuned in case our other experts see your note.

Dököll