Transfer to excel -- sql server (microsoft)

Tracy McKibben
7/10/2006 8:52:31 AM

[quoted text, click to view]

You can do this directly from your ASP/.NET/web-tool-of-choice by
specifying the proper ContentType, SQL doesn't have anything to do with it.

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

--
Tracy McKibben
MCDBA

Reggie
7/10/2006 9:45:57 AM

Hi and TIA! I have an ASP.Net(VB) 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. I'm using .Net 1.1 / VS2003
/ SQL Server 2000 / WinXP.
I originally posted on a .net site, but had no reply so figured I'd try
here.

Thanks for your time.

--

******************
Reggie

sql server (microsoft) : Transfer to excel