Help :XML file data formatting ??

[serge calderara]

Dear all,

I have a CSV file which contains different type of data which are not
classified at all. What I mean by classified is for instance that the second
field might not always correspond to "customer Name" but maybe the second
field on the third record in the file might correspond to telephone number.

In order to edit those data in aproper way I need first to tag each records
with proper information type. Type will later correspond to a single dataset
column name.

For that I need to read this CSV file and build the proper XML file node
format based on the type of information encounter.
I can have more than 100 csv files to read with the same formating.

I was thinking of creating an XML template and use that template to generate
correctly my XML files issue from the initial CSV file.

I have nver done that before and have no experience on that, could you help
me on how to proceed ? Is ita good aproach to do so ?

I think I could also read my file , field my field and then create the xml
file line by lien accordingly with proper nxmlnode name but sounds a bit heavy

The final idea is that for data edition, I will afterwards load XML file and
bind it to a dataset object.
Thanks for your help and you expericence
Regards
Serge