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 a Server Regards -- Andrew Prosser Richard Scranton wrote in message <351C6A86.55F6248A@ix.netcom.com>... >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> > >