ASP and XML

[jessie]

I want to read data in an Excel with ASP and write it to an XML format
file. How can I do this?

Thanks!

 

[Ray at]

You have replies to your first question about this.

nntp://msnews.microsoft.com/microsoft.public.inetserver.asp.general/[email protected]

Ray at work

 

[jessie]

Sorry, the link you gave below is not available. Can you explain it for
me? Thanks.

 

[Ray at]

Sorry. I was playing with nntp links today. Here were the replies, as I
don't feel like finding a link in Google Groups. :]

From Ray at work:

You can use ADO to read from an Excel file. Take a look at
www.connectionstrings.com for your connection string.

select * from [sheet1$]



From dlbjr (Discerning resolutions for the alms):

then save the recordset persisting to XML.



Ray at home