XML For a Delimiter Text File coming from SQL Tables

[meny21]

Hi guys,

Do you know if it is possible to do this on XML? somebody told me to verify this option.

I have two tables:

HeaderTable:
Index
field1 (InvoiceNo)
field2 (InvoiceDescription)

DetailTable
Index
Field1 (ItemCode)
Field2 (Item Description)

Can be one header and "N" details

For example:

InvoiceNo: 1000
InvoiceDescription: "My Invoice"

With some details:

ItemCode: 20
Item Description: "Book"

ItemCode: 30
Item Description: "Magazine"

And the output will be a delimiter text file like this:

1000|My Invoice|20|Book|30|Magazine

It is possible if this comes from a SQL Tables to convert to a delimiter Text File?

Some suggestions guys?

Thanks a lot!

MR

 

[harebrain]

Because we observed your similar question in the VB6 forum and had the same thought, yes, you can

Recordset.Save [i]filename[/i] adPersistXML