Title: Oracle to Excel
Thank you so much!! This works like a charm.
Laura
-Original Message-
From: Mercadante, Thomas F
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 07, 2002 6:39 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Oracle to Excel
ssage-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002
4:00 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Oracle to Excel
Thank you for your
response Tom. I received other
responses as well, and I know that I can comma delimit a
This is how I do it:
1) Set-up an ODBC data source using either the Oracle or MS ODBC driver.
2) In Excel, use the Date->Get External Data menu option
3) Specify the ODBC driver
4) In the Wizard, select the table columns, where and sort or Untick the box and use MS Qu
Title: Oracle to Excel
there
is an ODBC driver you can set up to handle this as I recall.
hth.
mike
-Original Message-From: Burton, Laura L.
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002
10:49 AMTo: Multiple recipients of list ORACLE-LSubject:
Oracle to Ex
Laura,
I have seen custom developed XLA's (Excel Add-Ins) for doing this, however
I have also seen a couple of commercial ones.
Check out www.oraxcel.com and their product SQL*XL - it provides what looks
like nice functionality although I only looked at the demo and never
purchased the commercial
Laura,
Check out Tom Kyte's site. He has posted the source code for a PL/SQL
package called OWA_SYLK that will dump a SQL query to a *.SLK file (*.SLK
files can be directly opened by Excel). Plug in the SQL and then go... send
the output file to the user and they do the rest.
Here is the link:
: Wednesday, November 06, 2002
1:24 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Oracle to Excel
Laura,
lots of tools do this for
you automatically. Oracle discoverer will export the results of a query
directly into Excel format.
You can do this yourself
as
Title: Oracle to Excel
Brain
freeze thats the only reason I did not think of it doh
!
-Original Message-From: Rodd Holman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002
1:39 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Oracle to ExcelIs th
If you can live with dumping to a comma delimited file, just do that
and import to Excel.
If you want to write directly to an Excel format, you could do that
with Perl. Have any Perl programmers around?
Here's an example of one. Not really too much code.
Jared
Title: Oracle to Excel
Is there a reason why you can't just extract it directly in to Excel using ODBC or Oracle Objects for OLE? ODBC would be the easiest, OO4OLE will give you the most control and better macro scripting for auto updating. Both of these come with the Oracle client install.
Title: Oracle to Excel
Laura,
lots
of tools do this for you automatically. Oracle discoverer will export the
results of a query directly into Excel format.
You
can do this yourself as follows:
in
SqlPLus
select
col1||chr(10)||col2||chr(10)
from
table.
the
chr(10) is the tab cha
Title: Oracle to Excel
I usually spool my queries to a .txt (ascii) file and import into Excel.
Easiest way for me. I’m sure there are other
more sophisticated solutions out there.
Regards,
Saira
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On Beha
Title: Oracle to Excel
Without extra software the easiest way is to setup a delimited file in a
sql statement and spool output to a file. Then import the file into a
spreadsheet.
If you
have it, Toad will save data into spreadsheets for you.
-Original Message-From: Burton, Laura
http://asktom.oracle.com and search for owa_sylk.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have
14 matches
Mail list logo