Hi,

Thanks for your response.

I have an applic written with VB6.0 and Access 2002. Before, I use to send 
to the server an email with a file in plain text but now, I will have to 
send it in XML. So, I need to construct this XML file but I wont be able to 
export it from a query because it to many datas from different tables. I can 
use VB.NET from now to make this XML file but I wonder how to start ?

Thanks for helping me.
Pierre

"Martin Honnen" <mahotrash@y...> a écrit dans le message de news: 
ulelUanTFHA.228@T......
>
>
> **Pierre** wrote:
>
>
>> I need to create a .xml file from data and send it by Email to be treated 
>> by other software. I wonder wich tool can I  use or do I have to create 
>> it from scratch and write it myself line after lines in a file.
>>
>> Off course, I have the schema of the XML file and the datas are in my 
>> database in many places.
>
> SQL server can return XML from an SQL query. As for mailing a document 
> that is certainly possible using existing components without implementing 
> SMTP yourself.
> What tools do you use or want to use, MSXML or .NET, a scripting language 
> like JScript or VBScript, or a language like VB or C#?
>
>
> -- 
>
> Martin Honnen --- MVP XML
> http://JavaScript.FAQTs.com/