Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: insert data into excel

RE: insert data into excel

From: William Beilstein <BeilstWH_at_obg.com>
Date: Thu, 03 Aug 2000 14:54:27 -0400
Message-Id: <10578.113777@fatcity.com>


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). Received on Thu Aug 03 2000 - 13:54:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US