[Hampshire] xml advice please

Hi

I confess to almost no knowledge of xml or using it in forms etc, and am
finding it tricky to decide what to learn form various resources. but here
is the problem I want to solve:

I need to throw a load of text data into a package. The package has import
xml as an option, and I have done a dummy import / export successfully.

The data is a few hundred records of 2 or 3 fields that currently live in an
open office spreadsheet, and I just want to create the import file like
this:

xml heading stuff

xml record header
some code <first field> more code <second field> and more <last field>
xml record footer

xml record header
some code <first field> more code <second field> and more <last field>
xml record footer

repeated for x records

xml footer stuff


I suppose the ideal would be some form of data merge on open office using
writer or base, but has anyone got any tips please? It's the kind of thing
that is probably an office type of trick as opposed to learning scripts or
other just for one task.

I will need to run the import once initially then every few months as a
small number of records gets added, for just one system.

Many thanks

Ed



--
Ed