Hello All

Does anyone have an "easy" way to convert a database records into an XML style file.

Ex. If I have a table Customer having fields FirstName, LastName,Address, Phone. I'd want to convert that to something like :

<Cusotmer>
<FirstName>Paul</FirstName>
<LastName>Smith</LastName>
<Address>555 Somewhere</Address>
<Phone>555-5555</Phone>
</Customer>
....
do this for each customer record in my database.

Once the file is made and FTP'd I'd use this to update a database in another location that is looking at this file. Is this feasable or is there a better way?

Thanks in Advance