Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Q: Convert query output to MS Excel
If you have MS SQL Server then look in MSSQL\SQLOLE\SAMPLES\VB you will see the sample VBA sqldmo.xls which uses SQLOLE and provides the following routines;
' Routines Provided:
' ChartDBUsage - Chart the Space usage for each database on a
Server
' ListDBObjects - List all Objects in a Database ' ListTableColumns - List Column information for a table ' UpdateTableStatistics - Update Statistics for all tables in a database ' ExecQuery - Execute a Query and Get Results Back ' ChartDeviceUsage - Chart the Space usage for each Device on aServer
Regards
-- Andrew Prosser Richard Scranton wrote in message <351C6A86.55F6248A_at_ix.netcom.com>...Received on Mon Mar 30 1998 - 00:00:00 CST
>I watched a demo at the Borland conference in Anaheim a while back
>where the demonstrator created a DLL using Delphi (v1.0, no less)
>that ran a query against a remote server. The demo-er then wrote
>a Word macro of about five lines to run the DLL from a tool bar button.
>
>The entire process took him about 10 minutes, starting from scratch.
>
>
>Alexey Pushkin wrote:
>
>> Could anyone recommend a good product for
>> converting query output to MS Excel and/or Word on the fly.
>> (For a web application).
>>
>> Thanks.
>
>
>
>--
>____________________________________________________
><a href="http://www.netcom.com/~scrantr/index.html">
>Richard Scranton - LDA Systems, Columbus Ohio </a>
>
>