Excel 2002 and later can read xml. I don't believe earlier versions can.

Comma delimited (CSV) should be readable by excel and would be the easiest.

--
Regards,
Tom Ogilvy

"paul reed" wrote in message
...
Hello,

I have a VB.NET app that uses SQL Server. The front-end is an ASP.NET app
that runs at an ISP. I would like to let my client pull up an ASPX page,
request some pre-canned query where they perhaps supply a transaction date
range for my job table, and then I want to run that query against SQL
Server. All of this stuff I can do with no problem...but the result of the
query isn't to be displayed on a web page. I would like to have it saved
on
the requesters machine in a format that excel can utilize.

Ideally after the query runs I would like it to prompt the user with a
file
dialog that asks them what filename would they like to save it to.

What is the best approach to take on this? Does the data have to be
formatted a particular way, comma delimited, xml?

Thanks...Paul