Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_cdo thread: Help with a Good Source of ASP and Excel integration


Message #1 by "John Mountain" <johnm@a...> on Fri, 15 Feb 2002 18:34:54
Please can anybody help with identifying a good source of how to establish 

an excel session in a browser window and control the output via asp pages.



I want to be able to:-

    . output data from a SQL Server database

    . select the data at the server from the database using parameters 

      collected at the client

    . display the results in an excel window in the browser as a 

      graph/chart

    . control the output to the excel window from the server via asp



Regards,



John M.



Message #2 by "Cesar SiempreEstoy" <cesar_soporte@h...> on Sat, 16 Feb 2002 18:16:05 +0000

     First: Say me that:

         If you show the data from SQL DataBase to the page using IDC 

(Internet DataBase Connector)



          OR



         You show the data from SQL DataBase to the page using DataControl 

in a ASP page.





     Second: If you want create parameters for show the data on the web-page 

you can make that using: IDC or DataControl (the same application for 

connecting the DataBase SQL and the web-page is the application for create 

parameters for the data, almost you can make that).



      Third and Fourth:



      I can´t say how see the result in the web-page as an excel expression, 

but I think you must use an ActiveX control, but I attempt find the answear.



Well, so, say me if you work to a IDC or DataControl, (I recommend IDC in 

any case), and I send you the code complete of a IDC, how you register the 

DataBase in the ODBC and how manage the SQL account in the SQL Server. All 

that is necesary for success if you work with a SQL Server.

Well,

Bye.

César



>From: "John Mountain" <johnm@a...>

>Reply-To: "ASP CDO" <asp_cdo@p...>

>To: "ASP CDO" <asp_cdo@p...>

>Subject: [asp_cdo] Help with a Good Source of ASP and Excel integration

>Date: Fri, 15 Feb 2002 18:34:54

>

>Please can anybody help with identifying a good source of how to establish

>an excel session in a browser window and control the output via asp pages.

>

>I want to be able to:-

>     . output data from a SQL Server database

>     . select the data at the server from the database using parameters

>       collected at the client

>     . display the results in an excel window in the browser as a

>       graph/chart

>     . control the output to the excel window from the server via asp

>

>Regards,

>

>John M.

>

>












_________________________________________________________________

Hable con sus amigos en línea, pruebe MSN Messenger: http://messenger.msn.es




  Return to Index