|
 |
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
|
|
 |