ASP and Excel

[Jessie]

How can I use ASP to read data in an Excel file and than write it in the
format of XML?

Thanks!

 

[Ray at]

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

select * from [sheet1$]

Ray at work

 

[dlbjr]

then save the recordset persisting to XML.