This code provides for the export of data from SQL server to Excel via two asp pages.
You coould go directly to the 02extoex.asp page without showing 01viewdata.asp which
is only there to show the user the data first.

=============================================================== 

PAGE ONE CALLED 01viewdata.asp :

<%@ Language=VBScript %>
<!-- #include

 
 
'Highlight searched for text function
Function Highlight(strText, strFind, strBefore, strAfter)
Dim nPos
Dim nLen
Dim nLenAll
 
nLen = Len(strFind)

 CONVERT(DateTime,GetDate(), 103)

 @Date varchar(10), -- The variable coming into the stored procedure. 
Date = CONVERT(DateTime,@Date, 103) -- The variable into the convert function.