asp and excel

[vlitim]

is it possible to get create an excel on the fly with asp. ie could someone come onto a webpage press a button and get an excel spreadsheet with the required data from an SQL dbase.

 

[foxbox]

Yes.
You can use the Data Transformation Services.
Under local Packages start a new package.
add a MS OLE DB provider-object as source SQL data and
a MS Excel-object (from the left) for the target data.
Click both objects (with shift) and add a workflow: 'Transform data'.


br
Gerard
(-:

 

[vlitim]

Once I have created the package how do I go about calling it from an asp page?

 

[foxbox]

dim oDTS
set oDTS = CreateObject("DTS.package&quot
oDTS.LoadFromSQLserver <server name>,&quot;sa&quot;, &quot;&quot;,,,,&quot;,<package name>
oDTS.execute
set oDTS = nothing


Maybe you need to change id/password!

br
Gerard
(-:

 

[foxbox]

dim oDTS
set oDTS = CreateObject(&quot;DTS.package&quot
oDTS.LoadFromSQLserver <server name>,&quot;sa&quot;, &quot;&quot;,,,,,&quot;<package name>
oDTS.execute
set oDTS = nothing


Maybe you need to change id/password!

br
Gerard
(-: