Returning excel spreadsheet

[Reggie]

Hi and TIA! I have a site that maintains parts for the military. They have
requested the ability to click a button on my site which will let them
upload a text file containing 100 or more part numbers. I will then place
them in an SQL temp table. I will then run a procedure that will query my
db for matching records and return a recordset of those matches which I will
display in a form. Then they want the ability to take this result set and
save it as an excel file. This is the part I'm having trouble with. If
you've done this before or know where I can find more info/examples of
accomplishing this task I would appreciate it. Thanks for your time.

 

[Reggie]

Forgot to mention I'm using .Net 1.1 / VS2003 / SQL Server 2000 / WinXP

 

[Guest]

Hi Reggie,


I recently did something similar (from a WinForms application), and I based
my solution on the following KB article:

http://support.microsoft.com/kb/285891

Hope this helps,

Joris