| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: insert data into excel
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFFD7C.F1BA87AE
Content-Type: text/plain;
charset="iso-8859-1"
Yes. Tie MS-QUERY to Excel and set up an ODBC driver to the database and
you will be in business.
Have fun!
-----Original Message-----
From: Joan Hsieh [mailto:jhsieh_at_infonet.tufts.edu]
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 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). ------_=_NextPart_001_01BFFD7C.F1BA87AE Content-Type: text/html; charset="iso-8859-1"Received on Thu Aug 03 2000 - 13:59:26 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>RE: insert data into excel</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Yes. Tie MS-QUERY to Excel and set up an ODBC driver to the database and you will be in business. </FONT>
<BR><FONT SIZE=2>Have fun!</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Joan Hsieh [<A HREF="mailto:jhsieh_at_infonet.tufts.edu">mailto:jhsieh_at_infonet.tufts.edu</A>]</FONT>
<BR><FONT SIZE=2>Sent: Thursday, August 03, 2000 1:20 PM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: insert data into excel</FONT>
</P>
<BR>
<P><FONT SIZE=2>Hi All,</FONT>
</P>
<P><FONT SIZE=2>Is there any way to insert the result from a query into excel? I know a</FONT>
<BR><FONT SIZE=2>year ago I saw someone did that. I just have no clue how to do it.</FONT>
<BR><FONT SIZE=2>For example: I want to get all the tablespace used bytes insert into</FONT>
<BR><FONT SIZE=2>excel directly. So I can calculate the growth rate from excel monthly. I</FONT>
<BR><FONT SIZE=2>don't want create tables to store those data in the database.</FONT>
</P>
<P><FONT SIZE=2>Thanks,</FONT>
</P>
<P><FONT SIZE=2>Joan</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Joan Hsieh</FONT>
<BR><FONT SIZE=2> INET: jhsieh_at_infonet.tufts.edu</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
 |
 |