re:convert database(text file) to xml

[Alvin]

hi , i have a problem of doing conversion between text file (export form db2)
into xml file ...i need guide ...thks!

[Russell Jones]

This might help:
Kurt Cagle's: Converting Fixed-Width Text Records to XML
http://gethelp.devx.com/techtips/xml...kc060501-1.asp

"Alvin" <cks8829@yahoo.com> wrote in message
news:3bc59952$1@news.devx.com...
>
> hi , i have a problem of doing conversion between text file (export form
db2)
> into xml file ...i need guide ...thks!

[Matt Hendryx]

"Alvin" asked about converting databases to xml. My "dirty" method has worked
quite well on a number of occassions. In my teaching environment most of
my documents are in Excel or some sort of .csv format. I have created a
spreadsheet in both Excel and in OpenOffice's scal that has worksheet one
as the import sheet for the data. Worksheet two spreads the data into every
other column. Then the top of each blank column on sheet 2 has the xml code
(usually the closing tag for the previous column and the start tag for the
next) entered. Copy these down the columns. Now copy this second sheet
and "paste special" and click "values" onto a third worksheet. Export this
third sheet as a txt or .csv file and you have an xml data base file. If
you do it in OpenOffice, you can specify the field delimiters to be empty.
This saves any touch up editing after you export the third worksheet.

In particular this technique works well if you want to convert your emails
to your own xml format. Export the folder as a .csv format, then bring into
OpenOffice and go through the conversion above.


"Russell Jones" <arj1@northstate.net> wrote:
>This might help:
>Kurt Cagle's: Converting Fixed-Width Text Records to XML
>http://gethelp.devx.com/techtips/xml...kc060501-1.asp
>
>"Alvin" <cks8829@yahoo.com> wrote in message
>news:3bc59952$1@news.devx.com...
>>
>> hi , i have a problem of doing conversion between text file (export form
>db2)
>> into xml file ...i need guide ...thks!
>
>