In article <7o2m28$44u$2_at_hyperion.nitco.com>,
"R. Nightingale" <nighr_at_hotmail.com> wrote:
> You can skip several steps by including the MS-Query option in the
> Excel/Office setup. Then you just make a query to an ODBC data
source. The
> results will always be in your excel spread sheet. If the database
table is
> updated between spreadsheet opens, your spread sheet will have the
latest
> values.
>
> The other way I do what you ask is to have a column of commas:
>
> spool c:\temp\whatever.csv
> select field1||','|| field2|| ','|| field3 from table;
> spool off
>
> Since you're opening a CSV file, the fields will already be delimited.
I'm
> assuming you installed PLUS80.EXE on your PC.
>
> --rn.
>
> David Haynor <haynor_at_u.washington.edu> wrote in message
> news:7nio9j$7ua$1_at_nntp6.u.washington.edu...
> > hi oracle wizards,
> >
> > i'd like to make a query, and then export the results, with tabs
between
> > columns and newlines between rows, to a file readable by MS Excel.
> > i believe that i can use SPOOL to do this, but how do i set the
column
> > separator to a tab?
> >
> > more generally, are there better ways to save the results of a query
in
> > an external file?
> >
> > thanks in advance.
> >
> > -dh
> > -david haynor (haynor_at_u.washington.edu)
> > department of radiology
> > box 356004
> > university of washington
> > seattle, WA 98195
> > (206) 543-3320
> >
> >
> >
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Aug 03 1999 - 12:08:09 CDT
