Best Way to get data out of SQL Server into Excel

  • Thread starter Thread starter paul reed
  • Start date Start date
P

paul reed

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
 
if you have an Access data project, you can shoot data out of the
database and into a spreadsheet quite easily
i would really try to get away from excel tho; it is a disease
 
Another fictitious reply to a non-existent post just to get a rant into the
newsgroups - Petty beyond belief.
 
you know what Ken?

you don't need to slam me

Access is a better ARCHITECTURE than Excel

you can reuse business logic instead of MAKING THE SAME DAMN XLS WEEK IN AND
WEEK OUT

JUST BECAUSE YOUR LIFE IS BORING DOESN'T MEAN IM WRONG
 
Back
Top