AW: insert data into excel

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Fri, 4 Aug 2000 11:03:08 +0200
Message-Id: <10579.113827@fatcity.com>

You can use direct access from Excel to Oralce via ODBC and MS Query. = Look
at the menu item for external data.

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----
Von: William Beilstein [mailto:BeilstWH_at_obg.com] Gesendet: Donnerstag, 3. August 2000 22:12 An: Multiple recipients of list ORACLE-L Betreff: RE: insert data into excel

Also you can build an actual Excel Spreadsheet using OLE calls.=20

>>> Steven Monaghan <Steve.Monaghan_at_wcom.com> 08/03/00 02:07PM >>>
You can create a csv (comma separated values) file that Excel can read = from
SQL*Plus by doing the following:

set colsep ,

Steve Monaghan

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Joan =
Hsieh
> Sent: Thursday, August 03, 2000 1:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: insert data into excel
>
>
> Hi All,
>
> Is there any way to insert the result from a query into excel? I know =
a
> year ago I saw someone did that. I just have no clue how to do it.
> For example: I want to get all the tablespace used bytes insert into
> excel directly. So I can calculate the growth rate from excel =
monthly. I
> don't want create tables to store those data in the database.
>
> Thanks,
>
> Joan
> --
> Author: Joan Hsieh
> INET: jhsieh_at_infonet.tufts.edu=20
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

--=20
Author: Steven Monaghan
INET: Steve.Monaghan_at_wcom.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--=20
Author: William Beilstein
INET: BeilstWH_at_obg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------